Advanced DBMS Interview Questions

  1. What is Two-Phase Locking (2PL)?

  2. How does 2PL prevent concurrency issues?

  3. What is Multiversion Concurrency Control (MVCC)?

  4. Difference between MVCC and locking-based concurrency control.

  5. What is Write-Ahead Logging (WAL)?

  6. What is ARIES recovery algorithm?

  7. What is the difference between B-Tree and B+ Tree?

  8. Why is B+ Tree preferred in databases?

  9. What is hashing in DBMS?

  10. What are static and dynamic hashing?

  11. What is extendible hashing?

  12. What is linear hashing?

  13. What is the CAP theorem?

  14. How does CAP theorem affect database design?

  15. What is BASE vs ACID?

  16. What are distributed databases?

  17. Types of distributed database architectures.

  18. How do distributed databases handle consistency?

  19. What is two-phase commit (2PC)?

  20. What is three-phase commit (3PC)?

  21. What is database mirroring?

  22. Difference between mirroring and replication.

  23. What is high availability in DBMS?

  24. What is fault tolerance?

  25. What is disaster recovery?

  26. Types of database backups.

  27. What is full backup?

  28. What is incremental backup?

  29. What is differential backup?

  30. What is online vs offline backup?

  31. What is query optimizer?

  32. How does a cost-based optimizer work?

  33. What are join algorithms?

  34. What is nested loop join?

  35. What is hash join?

  36. What is merge join?

  37. Difference between hash join and merge join.

  38. What is full-text indexing?

  39. What is database tuning?

  40. What is connection pooling?

  41. Why is connection pooling important?

  42. What is optimistic locking?

  43. What is pessimistic locking?

  44. Difference between optimistic and pessimistic locking.

  45. What is polyglot persistence?

  46. What are NoSQL databases?

  47. Types of NoSQL databases.

  48. Difference between SQL and NoSQL databases.

  49. What is NewSQL?

  50. What are in-memory databases?

  51. How do databases handle very large datasets?

  52. What is horizontal scaling?

  53. What is vertical scaling?

  54. What are the challenges of big data with RDBMS?

  55. How is database security implemented?

  56. What is data encryption at rest and in transit?

  57. What is data masking?

  58. How does DBMS support multi-tenancy?

  59. What is GDPR and its impact on database design?

  60. What are emerging trends in database technologies?