Top DBMS Interview Questions and Answers for Beginners & Experts

DBMS Interview Questions with Answers

1. What is DBMS?

Answer: A Database Management System (DBMS) is software that allows users to store, retrieve, and manage data efficiently. Examples include MySQL, PostgreSQL, Oracle, and MongoDB.

2. What is the difference between DBMS and RDBMS?

Answer:

• DBMS: Stores data as files, does not enforce relationships (e.g., hierarchical, network databases).
• RDBMS: Stores data in tables with relationships, follows ACID properties, and supports SQL (e.g., MySQL, PostgreSQL).

3. What are ACID properties in DBMS?

Answer:

1. Atomicity – Transactions are all-or-nothing.
2. Consistency – Ensures valid state transitions.
3. Isolation – Transactions run independently.
4. Durability – Data remains even after a crash.

4. What is Normalization? Why is it important?

Answer: Normalization reduces redundancy and improves data integrity by organizing data into multiple tables. It prevents anomalies and ensures efficient storage.

5. What are the different types of Normal Forms?

Answer:

• 1NF: Removes duplicate columns, ensures unique values.
• 2NF: Eliminates partial dependencies.
• 3NF: Removes transitive dependencies.
• BCNF: Ensures strict dependency rules.

6. What is Denormalization?

Answer: It is the opposite of normalization, used to improve query performance by introducing redundancy.

7. What is the difference between Primary Key and Unique Key?

Answer:

• Primary Key: Uniquely identifies records, cannot be NULL.
• Unique Key: Ensures uniqueness but allows NULL values.

8. What is an Index in DBMS?

Answer: An index speeds up queries by allowing faster data retrieval. Types include Primary Index, Secondary Index, Clustered, and Non-clustered Indexes.

9. What is SQL Injection?

Answer: SQL Injection is a security vulnerability where an attacker injects malicious SQL queries. Prevention: Use prepared statements, parameterized queries, and input validation.

10. What is the difference between DELETE, TRUNCATE, and DROP?

Answer:

• DELETE: Removes records with a condition, can be rolled back.
• TRUNCATE: Deletes all rows, resets identity, cannot be rolled back.
• DROP: Removes the entire table structure.