Intermediate DBMS Interview Questions

  1. What is a transaction in DBMS?

  2. What are the ACID properties of a transaction?

  3. What is transaction management?

  4. What is concurrency control?

  5. Why is concurrency control required?

  6. What are the different types of locks in DBMS?

  7. What is a shared lock?

  8. What is an exclusive lock?

  9. What is a deadlock in DBMS?

  10. How can deadlocks be prevented?

  11. What is deadlock detection?

  12. What is deadlock prevention?

  13. What is deadlock avoidance?

  14. What is a transaction log?

  15. What is recovery management?

  16. What is a checkpoint in DBMS?

  17. What is durability in DBMS?

  18. What is isolation in DBMS?

  19. What are isolation levels?

  20. What are dirty reads?

  21. What are non-repeatable reads?

  22. What are phantom reads?

  23. What is normalization?

  24. What are normal forms?

  25. Explain 1NF.

  26. Explain 2NF.

  27. Explain 3NF.

  28. Explain BCNF.

  29. What is data redundancy and how is it reduced?

  30. What is a functional dependency?

  31. What is multivalued dependency?

  32. What is join dependency?

  33. What is indexing in DBMS?

  34. What are the different types of indexes?

  35. What is a clustered index?

  36. What is a non-clustered index?

  37. Difference between clustered and non-clustered index.

  38. What is query optimization?

  39. What is query processing?

  40. What is a stored procedure?

  41. What are the advantages of stored procedures?

  42. What is a trigger?

  43. Difference between trigger and stored procedure.

  44. What is a materialized view?

  45. Difference between view and materialized view.

  46. What is database partitioning?

  47. Difference between horizontal and vertical partitioning.

  48. What is database replication?

  49. Types of database replication.

  50. What is database sharding?

  51. Difference between sharding and partitioning.

  52. What is OLTP?

  53. What is OLAP?

  54. Difference between OLTP and OLAP.

  55. What is data warehousing?

  56. Difference between ER diagram and relational schema.

  57. What is UNION?

  58. What is UNION ALL?

  59. Difference between UNION and UNION ALL.

  60. What is CHAR vs VARCHAR?

  61. What is a cursor and when is it used?

  62. What is database schema evolution?

  63. What is ORM (Object Relational Mapping)?

  64. What is referential action (CASCADE, SET NULL)?

  65. What is a many-to-many relationship and how is it implemented?