Beginner / Basic DBMS Interview Questions

  1. What is a Database Management System (DBMS)?

  2. What is a database?

  3. What is the difference between a database and a DBMS?

  4. What are the advantages of using a DBMS?

  5. What are the disadvantages of DBMS?

  6. What are the main functions of a DBMS?

  7. What are the different types of DBMS?

  8. What is RDBMS?

  9. What is the difference between DBMS and RDBMS?

  10. What are the different database models?

  11. What is a table in DBMS?

  12. What is a relation in DBMS?

  13. What are rows and columns in a table?

  14. What is a database schema?

  15. What is an instance of a database?

  16. What is data redundancy?

  17. How does DBMS reduce data redundancy?

  18. What is data independence?

  19. What are the different levels of data abstraction?

  20. What is an ER diagram?

  21. What is an entity?

  22. What is an attribute?

  23. What is an entity set?

  24. What is a relationship in DBMS?

  25. What are the different types of relationships?

  26. What is a primary key?

  27. What is a foreign key?

  28. What is a candidate key?

  29. What is a super key?

  30. What is a composite key?

  31. What is a surrogate key?

  32. What is a unique key?

  33. What are database constraints?

  34. What are the different types of constraints in DBMS?

  35. What is normalization?

  36. Why is normalization important?

  37. What is denormalization?

  38. What is SQL?

  39. What are the different types of SQL commands?

  40. What is DDL?

  41. What is DML?

  42. What is DCL?

  43. What is TCL?

  44. What is a view?

  45. What is the difference between a view and a table?

  46. What is indexing?

  47. What is an index?

  48. What is data integrity?

  49. What is referential integrity?

  50. What is ACID in DBMS?

  51. Are NULL values same as zero or blank?

  52. What is DELETE command?

  53. What is TRUNCATE command?

  54. What is DROP command?

  55. What is the difference between DELETE, TRUNCATE, and DROP?

  56. What is a join in SQL?

  57. What are the different types of joins?

  58. What is INNER JOIN?

  59. What is OUTER JOIN?

  60. What is GROUP BY clause?

  61. What is HAVING clause?

  62. What are aggregate functions?

  63. What is a subquery?

  64. What is a database cursor?

  65. What is a data dictionary?

  66. What is a database administrator (DBA)?