DBMS is a core subject in almost every campus and early-career technical interview — TCS, Infosys, Wipro, Accenture, and most product companies test it. The concepts are finite and predictable, and they pair naturally with SQL questions. Here are the DBMS interview questions that actually get asked, with answers.
Keys & relationships
- Primary key vs candidate key vs super key vs foreign key.
- Unique key vs primary key.
- What is a composite key?
- What is referential integrity?
Normalization
- What is normalization and why do we do it?
- Explain 1NF, 2NF, 3NF, and BCNF with examples.
- What are partial and transitive dependencies?
- When would you denormalize, and why?
Transactions & ACID
- Explain ACID — atomicity, consistency, isolation, durability.
- What is a transaction? What are commit and rollback?
- Isolation levels and the problems they prevent (dirty read, non-repeatable read, phantom read).
- What is a deadlock and how is it handled?
Indexing & joins
- What is an index, and how does it speed up reads (and cost writes)?
- Clustered vs non-clustered index.
- Types of joins — inner, left, right, full (our SQL guide).
- DBMS vs RDBMS; SQL vs NoSQL.
How to prepare
DBMS rounds are explanation-heavy: "explain 3NF with an example", "why use an index". Practise saying these out loud with examples. Greenroom runs spoken technical interviews that follow up on your answers and give feedback. Pair it with our SQL and OS guides.
Frequently asked questions
What are the most common DBMS interview questions?
Common DBMS questions cover keys (primary, candidate, super, foreign, composite), normalization (1NF through BCNF, partial and transitive dependencies, when to denormalize), transactions and ACID, isolation levels and the read anomalies they prevent, deadlocks, indexing (clustered vs non-clustered), join types, and DBMS vs RDBMS and SQL vs NoSQL.
What is normalization and why is it important?
Normalization is organizing database tables to reduce redundancy and avoid update, insert and delete anomalies. It progresses through normal forms — 1NF removes repeating groups, 2NF removes partial dependencies, 3NF removes transitive dependencies, and BCNF handles certain edge cases. It keeps data consistent, though it's sometimes relaxed (denormalized) for read performance.
What does ACID stand for in DBMS?
ACID describes the guarantees of a reliable transaction: Atomicity (all operations succeed or none do), Consistency (a transaction moves the database from one valid state to another), Isolation (concurrent transactions don't interfere, governed by isolation levels), and Durability (committed changes survive crashes). Together they keep data correct under failures and concurrency.
How should I prepare for a DBMS interview?
Focus on understanding the 'why' behind keys, normalization, ACID and indexing, and prepare a crisp real-world example for each concept since interviewers ask you to explain with examples. Then practise saying those explanations out loud, ideally with a voice-based mock interview that follows up, because DBMS rounds are explanation-heavy and verbal.