DBMS Interview Questions & Answers
DBMS Interview Online Test
1. Explain the ACID properties in the context of a database transaction
Show Answer
2. What is a deadlock in DBMS and how can it be prevented
Show Answer
3. Describe the differences between primary key and unique key in a database
Show Answer
4. What is normalization and why is it important in database design
Show Answer
5. Explain the concept of a foreign key and its role in relational databases
Show Answer
6. What are the differences between OLTP and OLAP systems in DBMS
Show Answer
7. How does indexing improve query performance in a database
Show Answer
8. What is the difference between a clustered and a non-clustered index
Show Answer
9. Explain the concept of database partitioning and its advantages
Show Answer
10. What are the different types of joins in SQL and when would you use each type
Show Answer
11. What is a materialized view and how does it differ from a regular view
Show Answer
12. Explain the concept of transaction isolation levels and their impact on concurrency
Show Answer
13. What is the difference between star schema and snowflake schema in data warehousing
Show Answer
14. How does the two-phase commit protocol work in distributed databases
Show Answer
15. Describe the concept of database sharding and its benefits
Show Answer
16. What are the key differences between NoSQL and SQL databases
Show Answer
17. How does the CAP theorem apply to distributed databases
Show Answer
18. What is the difference between a hash join and a merge join in query processing
Show Answer
19. Explain the concept of query optimization and the role of the query optimizer
Show Answer
20. How do database triggers work and what are their typical use cases
Show Answer
21. Describe the differences between a correlated subquery and a non-correlated subquery
Show Answer
22. What are the different types of data models in DBMS and their applications
Show Answer
23. How does the concept of eventual consistency differ from strong consistency in distributed databases
Show Answer
24. What are bitmap indexes and in what scenarios are they most useful
Show Answer
25. Explain the concept of a self-join and provide an example of its use
Show Answer