Top 100 DBMS Questions and Answers for Placement
Q1. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Q2. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q3. What is a primary key?
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q4. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
relationship between tables.
Q5. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Q6. Explain 1NF, 2NF, 3NF.
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q7. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
relational databases.
Q8. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Q9. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
Page 1
Top 100 DBMS Questions and Answers for Placement
additional storage space.
Q10. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
manage data in databases.
Q11. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Q12. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q13. What is a primary key?
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q14. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
relationship between tables.
Q15. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Q16. Explain 1NF, 2NF, 3NF.
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q17. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
relational databases.
Page 2
Top 100 DBMS Questions and Answers for Placement
Q18. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Q19. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
additional storage space.
Q20. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
manage data in databases.
Q21. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Q22. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q23. What is a primary key?
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q24. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
relationship between tables.
Q25. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Q26. Explain 1NF, 2NF, 3NF.
Page 3
Top 100 DBMS Questions and Answers for Placement
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q27. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
relational databases.
Q28. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Q29. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
additional storage space.
Q30. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
manage data in databases.
Q31. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Q32. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q33. What is a primary key?
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q34. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
relationship between tables.
Page 4
Top 100 DBMS Questions and Answers for Placement
Q35. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Q36. Explain 1NF, 2NF, 3NF.
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q37. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
relational databases.
Q38. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Q39. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
additional storage space.
Q40. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
manage data in databases.
Q41. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Q42. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q43. What is a primary key?
Page 5
Top 100 DBMS Questions and Answers for Placement
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q44. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
relationship between tables.
Q45. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Q46. Explain 1NF, 2NF, 3NF.
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q47. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
relational databases.
Q48. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Q49. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
additional storage space.
Q50. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
manage data in databases.
Q51. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Page 6
Top 100 DBMS Questions and Answers for Placement
Q52. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q53. What is a primary key?
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q54. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
relationship between tables.
Q55. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Q56. Explain 1NF, 2NF, 3NF.
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q57. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
relational databases.
Q58. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Q59. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
additional storage space.
Q60. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
Page 7
Top 100 DBMS Questions and Answers for Placement
manage data in databases.
Q61. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Q62. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q63. What is a primary key?
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q64. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
relationship between tables.
Q65. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Q66. Explain 1NF, 2NF, 3NF.
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q67. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
relational databases.
Q68. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Page 8
Top 100 DBMS Questions and Answers for Placement
Q69. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
additional storage space.
Q70. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
manage data in databases.
Q71. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Q72. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q73. What is a primary key?
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q74. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
relationship between tables.
Q75. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Q76. Explain 1NF, 2NF, 3NF.
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q77. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
Page 9
Top 100 DBMS Questions and Answers for Placement
relational databases.
Q78. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Q79. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
additional storage space.
Q80. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
manage data in databases.
Q81. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Q82. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q83. What is a primary key?
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q84. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
relationship between tables.
Q85. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Page 10
Top 100 DBMS Questions and Answers for Placement
Q86. Explain 1NF, 2NF, 3NF.
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q87. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
relational databases.
Q88. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Q89. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
additional storage space.
Q90. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
manage data in databases.
Q91. What is the difference between DBMS and RDBMS?
Ans: RDBMS is a type of DBMS with a relational model that supports relationships using tables with
rows and columns.
Q92. What are ACID properties?
Ans: ACID stands for Atomicity, Consistency, Isolation, Durability. They ensure reliable processing
of database transactions.
Q93. What is a primary key?
Ans: A primary key is a column (or set of columns) that uniquely identifies each row in a table.
Q94. What is a foreign key?
Ans: A foreign key is a field in one table that uniquely identifies a row in another table, establishing a
Page 11
Top 100 DBMS Questions and Answers for Placement
relationship between tables.
Q95. What is normalization?
Ans: Normalization is the process of organizing data to reduce redundancy and improve data
integrity.
Q96. Explain 1NF, 2NF, 3NF.
Ans: 1NF: Atomic columns; 2NF: No partial dependency; 3NF: No transitive dependency.
Q97. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for managing and manipulating
relational databases.
Q98. What is a JOIN? Name types of joins.
Ans: JOIN is used to combine rows from two or more tables. Types: INNER JOIN, LEFT JOIN,
RIGHT JOIN, FULL JOIN.
Q99. What is indexing?
Ans: Indexing improves the speed of data retrieval operations on a database table at the cost of
additional storage space.
Q100. What is DBMS?
Ans: DBMS stands for Database Management System. It is software used to store, retrieve, and
manage data in databases.
Page 12
