All About DBMS - Interview Question and Answers

1. What are the differences between a DBMS and RDBMS? 2. Explain the terms database and DBMS. Also, mention the different types of DBMS. 3. What are the advantages of DBMS? 4. Mention the different languages present in DBMS 5. What do you understand by query optimization? 6. Do we consider NULL values the same as that of blank space or zero? 7. What do you understand by aggregation and atomicity? 8. What are the different levels of abstraction in the DBMS? 9. What is an entity-relationship model? 10. What do you understand by the terms Entity, Entity Type, and Entity Set in DBMS? 11. What are relationships and mention different types of relationships in the DBMS 12. What is concurrency control? 13. What are the ACID properties in DBMS? 14. What is normalization and what are the different types of normalization? 15. What are the different types of keys in the database? 16. What do you understand by correlated subqueries in DBMS? 17. Explain Database partitioning and its importance. 18. What do you understand by functional dependency and transitive dependency in DBMS? 19. What is the difference between two and three-tier architectures? 20. Mention the differences between Unique Key and Primary Key 21. What is a checkpoint in DBMS and when does it occur? 22. Mention the differences between Trigger and Stored Procedures 23. What are the differences between Hash join, Merge join and Nested loops? 24. What do you understand by Proactive, Retroactive and Simultaneous Update? 25. What are indexes? Mention the differences between the clustered and non-clustered index 26. What do you understand by intension and extension? 27. What do you understand by cursor? Mention the different types of cursor A cursor is a database object which helps in manipulating data, row by row and represents a result set. 28. Explain the terms specialization and generalization 29. What do you understand by Data Independence? 30. What are the different integrity rules present in the DBMS? 31. What does Fill Factor concept mean with respect to indexes? 32. What is Index hunting and how does it help in improving query performance? 33. What are the differences between network and hierarchical database model? 34. Explain what is a deadlock and mention how it can be resolved? 35. What are the differences between an exclusive lock and a shared lock?