18 Important DBMS Interview Questions And Answers
Interview Questions for Database Management Systems (DBMS)
1. What is a database management system (DBMS) and what is its purpose? Use examples to explain RDBMS.
2. What exactly is a database?
3. What are the drawbacks of traditional file-based systems that make a database management system a superior option?
4. Describe some of the benefits of a database management system.
5. Describe the different DBMS languages.
6. What does it mean to have ACID qualities in a database management system?
7. In a database, are NULL values the same as blank space or zero?
Interview Questions for Intermediate DBMS
8. What does Data Warehousing imply?
9. Describe the various layers of data abstraction in a database management system.
What does an entity-relationship (E-R) model imply? In a database management system, define the terms entity, entity type, and entity set.
11. Describe the various types of relationships between tables in a database management system.
12. In a database, what is the difference between intension and extension?
13. Describe the differences between the DELETE and TRUNCATE commands in a database management system.
14. Describe a lock. Explain the significant differences between a shared lock and an exclusive lock in a database transaction.
15. What do normalization and denormalization imply?
Questions for Advanced DBMS Interviews
16. Describe the many types of normalization forms in a database management system.
17. Describe the many types of database keys.
18. Describe the differences between a DBMS's 2-tier and 3-tier architecture.