SWE Interview - Set 6

Question 1

What are the Design Principles covered so far?

Answer 1

• Separation of Concerns
• Coupling
• Abstraction
• Inversion of Control

Question 2

What are the Design Patterns covered so far?

Answer 2

• Dependency Injection

Question 3

What do you need to work in an agile way?

Answer 3

A clear understanding of the desired outcomes

Question 4

The Ideal Team Player by Patrick Lencioni talks about the three qualities needed to be a successful team player.

Answer 4

• Humble: Treats everyone as an equal and doesn’t see themselves as “superior” to others
• Hungry: Seeks out new opportunities. Enjoys their work.
• Smart: Understands how to communicate & interact with others on their team

Question 5

Throttle

Answer 5

Controlling or limiting data flow or requests in a system to prevent overload and optimize performance in cloud computing. It ensures stability and prevent resource overuse.

In cloud computing is limiting the number of API requests a user can make within a specific timeframe to prevent overwhelming a server or service.

Question 6

Caching

Answer 6

Caching in development stores frequently accessed data temporarily, improving performance by reducing load times. It enhances efficiency by retrieving stored information rather than reprocessing or fetching it anew.

Question 7

WebSocket API

Answer 7

WebSocket API facilitates real-time, bidirectional communication between a client and server over a single, persistent connection, allowing instant data exchange, ideal for applications requiring continuous updates or immediate responses.

Question 8

Primary Key (PK)

Answer 8

A primary key in SQL uniquely identifies each row in a table, ensuring no duplicate values, facilitating data retrieval, and enforcing data integrity.

Question 9

Unique Constraint

Answer 9

A unique constraint in SQL ensures that values in a column or set of columns are unique within a table, preventing duplicate entries.

Question 10

What are the four ACID principles in database transactions, and what does each principle ensures?

Answer 10

• Atomicity: Transactions are indivisible units; either all operations succeed or fail together, maintaining database integrity and consistency.
• Consistency: Transactions maintain data integrity, moving the database from one valid state to another without violating constraints or rules.
• Isolation: Concurrent transactions operate independently, preventing interference, ensuring data integrity, and avoiding issues like dirty or inconsistent reads.
• Durability: Committed transaction changes persist permanently, surviving system failures, ensuring data remains intact and accessible after disruptions.

Question 11

What is the concept of Transactions in database?

Answer 11

Transactions in databases represent a set of operations treated as a single unit, ensuring reliability and consistency. They follow ACID properties.