MySQL + SQL · Lesson 125

DBMS Interview Questions and Answers

In this lesson: DBMS interview questions for freshers — keys, normalization, ACID, joins, indexing — clear answers with examples. Prepare fast.

How to use this list

These are the DBMS questions that come up most often in fresher interviews. Understand the idea behind each and give a short, clear answer with an example. Knowing why matters far more to interviewers than memorising definitions.

💡 For each answer, give the "why" plus a tiny example — that separates a strong answer from a memorised one.

Basics

Q1. What is a DBMS? Software to store, manage and retrieve data safely and efficiently.

Q2. DBMS vs RDBMS? An RDBMS stores data in related tables with keys; a DBMS may not.

Q3. What is a schema vs an instance? Schema is the structure (design); an instance is the actual data at a moment.

Q4. What is data independence? Changing one level (storage or logical) without affecting the levels above.

Q5. What are the types of data models? Hierarchical, network, relational and object-oriented; relational is the most common.

Keys and relationships

Q6. Primary key? Uniquely identifies each row; never null, one per table.

Q7. Foreign key? References another table's primary key, linking the tables.

Q8. Candidate vs super key? A candidate key is a minimal super key; a super key may have extra columns.

Q9. Composite key? A key made of two or more columns together.

Q10. What is referential integrity? A foreign key must point to an existing row or be null.

Normalization

Q11. What is normalization? Organising tables to reduce redundancy through normal forms.

Q12. 1NF? Every cell holds a single value; rows are unique.

Q13. 2NF? In 1NF, with no partial dependency on a composite key.

Q14. 3NF? In 2NF, with no transitive dependency between non-key columns.

Q15. What is denormalization? Adding some redundancy back to speed up reads.

Transactions and more

Q16. What is a transaction? A group of operations that succeed or fail together.

Q17. ACID properties? Atomicity, Consistency, Isolation, Durability.

Q18. COMMIT vs ROLLBACK? COMMIT saves changes; ROLLBACK undoes them.

Q19. DELETE vs TRUNCATE vs DROP? Rows (undoable) vs all rows (fast) vs whole table.

Q20. What is an index? A structure that speeds up searching, at the cost of extra storage and slower writes.

Interview tips

Explain the why. Say when and why to use a feature, not just what it is.
Give a one-line example. A tiny example shows real understanding.
Know keys and normalization cold. They are the heart of DBMS interviews.
Be honest. If unsure, say how you would find out — that reads well too.

Summary

Know DBMS vs RDBMS, schema vs instance, and data independence.
Explain keys clearly: primary, foreign, candidate, composite.
Be fluent in 1NF, 2NF, 3NF and denormalization.
Understand transactions and ACID properties.
Answer with the "why" plus a short example, not just definitions.

Revise the topics in normalization and keys in DBMS before your interview.

Frequently Asked Questions

What is the difference between DBMS and RDBMS?

A DBMS manages data, but an RDBMS specifically stores data in related tables and follows the relational model with keys and constraints. Every RDBMS is a DBMS, but not every DBMS organises data into related tables.

What is normalization and why is it used?

Normalization organises tables to reduce redundancy and avoid update problems, by splitting data into related tables through normal forms (1NF, 2NF, 3NF). It keeps each fact stored once, so updates stay consistent.

What is the difference between a primary key and a foreign key?

A primary key uniquely identifies each row in its own table and cannot be null. A foreign key is a column that references another table's primary key, linking the two tables and enforcing referential integrity.

What are ACID properties?

ACID stands for Atomicity, Consistency, Isolation and Durability. They ensure transactions are reliable: a group of changes fully succeeds or fully fails, data stays valid, transactions do not interfere, and committed data is never lost.

What is the difference between DELETE, TRUNCATE and DROP?

DELETE removes chosen rows and can be rolled back; TRUNCATE quickly removes all rows and resets the table; DROP removes the whole table including its structure. DELETE is DML, while TRUNCATE and DROP are DDL.