DBMS is a core subject in campus placements and fresher interviews in India. These DBMS interview questions and answers cover what interviewers ask most, with short answers you can say in under a minute. Pair them with SQL interview questions for freshers.
DBMS Basics (Q1–Q8)
1. What is a DBMS?
Software that stores, manages and retrieves data, handling security, concurrency and recovery. Examples: MySQL, Oracle, PostgreSQL, SQL Server.
2. DBMS vs RDBMS?
An RDBMS stores data in related tables with keys and supports SQL and integrity constraints; DBMS is the broader term.
3. Advantages of a DBMS over files?
Less redundancy, data integrity, concurrent access, security, backup and recovery, and a query language.
4. What is a schema?
The logical structure of a database: tables, columns, types, keys and relationships.
5. What are the three levels of abstraction?
Physical (how data is stored), logical (what data and relationships exist) and view (what each user sees).
6. What is data independence?
Changing one level without affecting the level above; logical and physical data independence.
7. What is an ER model?
A diagram of entities, attributes and relationships used to design a database.
8. Types of relationships?
One-to-one, one-to-many and many-to-many (implemented with a junction table).
Keys (Q9–Q14)
9. Super key?
Any set of columns that uniquely identifies a row.
10. Candidate key?
A minimal super key; a table can have several.
11. Primary key?
The candidate key chosen to identify rows; unique and not NULL.
12. Alternate key?
A candidate key not chosen as primary.
13. Foreign key?
A column referencing another table's primary key.
14. Composite and surrogate keys?
A composite key uses several columns; a surrogate key is a system-generated ID with no business meaning, common in data warehouses.
Normalisation (Q15–Q20)
15. What is normalisation?
Organising tables to reduce redundancy and avoid insert, update and delete anomalies.
16. 1NF?
Atomic values in each column and no repeating groups.
17. 2NF?
1NF plus no partial dependency: non-key columns depend on the whole composite key.
18. 3NF?
2NF plus no transitive dependency: non-key columns depend only on the key.
19. BCNF?
A stricter 3NF where every determinant is a candidate key.
20. What is denormalisation and when is it used?
Deliberately adding redundancy to speed up reads, common in data warehouses and reporting. See star vs snowflake schema.
Transactions and Concurrency (Q21–Q27)
21. What is a transaction?
A group of operations treated as one unit: all succeed or none do.
22. ACID properties?
Atomicity, Consistency, Isolation and Durability.
23. What problems does concurrency cause?
Dirty reads, non-repeatable reads, phantom reads and lost updates.
24. Isolation levels?
Read uncommitted, read committed, repeatable read and serializable, from weakest to strongest.
25. What is a deadlock?
Two transactions each waiting for a lock the other holds; the DBMS resolves it by aborting one.
26. What is locking?
Preventing conflicting access with shared (read) and exclusive (write) locks.
27. How does a DBMS recover from failure?
Using transaction logs to redo committed changes and undo uncommitted ones, plus backups and checkpoints.
Indexing and Storage (Q28–Q32)
28. What is an index?
A data structure, usually a B-tree, that speeds up searches on columns.
29. Clustered vs non-clustered index?
A clustered index defines the physical order of rows (one per table); a non-clustered index is a separate structure pointing to rows.
30. When can indexes hurt?
They slow down inserts and updates and use storage; too many indexes on write-heavy tables is a problem.
31. What is a view?
A virtual table defined by a query; a materialised view stores the result physically.
32. Stored procedure vs function?
Procedures can perform actions and return multiple results; functions return a value and can be used inside queries.
Modern Topics (Q33–Q35)
33. SQL vs NoSQL?
SQL databases use structured tables and strong consistency; NoSQL databases (document, key-value, column, graph) trade some structure for scale and flexibility.
34. OLTP vs OLAP?
OLTP handles day-to-day transactions; OLAP supports analysis on historical data in a data warehouse. See data warehouse concepts.
35. What is a data warehouse?
A central store of integrated historical data for reporting, loaded by ETL processes. Testing it is ETL testing.
Moving from DBMS theory to a data career? Practise applied questions with the ETL Testing Interview Questions & Answers – Practice Tests, and see database testing interview questions.
Prepare for your ETL testing interview: top 50 questions · in-depth answers · for experienced (3–5 years) · for 10 years experience · SQL query questions · scenario-based questions · data warehouse questions · questions for freshers · free mock test · database testing questions · Python ETL testing questions · Informatica questions · SQL questions for freshers · data validation questions · service-company questions
Data warehouse basics: data warehouse concepts · star vs snowflake schema · fact and dimension tables · SCD types · data reconciliation · data warehouse testing · data warehouse interview questions
Frequently Asked Questions
What are the most important DBMS topics for interviews?
Keys, normalisation (1NF to BCNF), ACID and transactions, concurrency and isolation levels, indexing, ER modelling, and SQL basics.
What is the difference between DBMS and RDBMS?
An RDBMS stores data in related tables with keys and integrity constraints and uses SQL. DBMS is the broader term for any database management software.
What are ACID properties?
Atomicity, consistency, isolation and durability, which together guarantee reliable transactions.
What is normalisation in DBMS?
The process of organising tables to reduce redundancy and avoid update anomalies, usually up to 3NF or BCNF.
How do I prepare DBMS for placements?
Revise these core topics, practise SQL queries daily and be ready to explain each concept with a small example.
Asim Noaman Lodhi
Certified Google Partner · QA Consultant · 12+ Years IT
QA consultant specializing in ETL testing and data quality. Trained 913+ students to transition into data testing roles through hands-on, real-world instruction.