MySQL + SQL · Lesson 124
DBMS Interview Questions
Common DBMS Interview Questions
Frequently asked DBMS questions with short answers — useful for placements and viva.
Questions & Answers
| Question | Short Answer |
|---|---|
| What is DBMS? | Software to store, manage and retrieve data. |
| DBMS vs RDBMS? | RDBMS stores data in related tables with keys. |
| What is normalization? | Organizing tables to reduce redundancy. |
| Primary vs foreign key? | Primary = unique ID; foreign = link to another table. |
| What are ACID properties? | Atomicity, Consistency, Isolation, Durability. |
| DELETE vs TRUNCATE? | DELETE = rows with WHERE; TRUNCATE = all rows, faster. |
Summary
- Know DBMS/RDBMS, keys, normalization, ACID, and DELETE vs TRUNCATE.
- Keep answers short and example-backed in interviews.