💻 Coding Interview Questions

1️⃣ What is a database?
Answer: An organized collection of data for efficient storage and retrieval.

2️⃣ What is SQL?
Answer: Structured Query Language used to manage relational databases.

3️⃣ What is a primary key?
Answer: A unique identifier for each record in a table.

4️⃣ What is a foreign key?
Answer: A key that links one table to another.

5️⃣ What is normalization?
Answer: Organizing data to reduce redundancy.

6️⃣ What is an index in a database?
Answer: A structure that improves data retrieval speed.

7️⃣ What is a JOIN?
Answer: Combines rows from multiple tables based on a condition.

8️⃣ INNER JOIN vs LEFT JOIN?
Answer: INNER returns matching rows; LEFT returns all left-table rows.

9️⃣ What is ACID?
Answer: Atomicity, Consistency, Isolation, Durability.

🔟 What is a transaction?
Answer: A sequence of database operations executed as a single unit.