Database Management Systems MCQ

Practice the most important Database Management Systems MCQ MCQs with answers and detailed explanations to improve your preparation.

Q1. What does DBMS stand for?

📘 View Explanation

Q2. Which of the following is an example of DBMS?

📘 View Explanation

Q3. In DBMS, what is a table also called?

📘 View Explanation

Q4. What is a row in a database table called?

📘 View Explanation

Q5. What is a column in a database table called?

📘 View Explanation

Q6. Which key uniquely identifies a row in a table?

📘 View Explanation

Q7. What is a foreign key used for?

📘 View Explanation

Q8. Which SQL command is used to extract data from a database?

📘 View Explanation

Q9. Which SQL command is used to add new data?

📘 View Explanation

Q10. Which SQL keyword is used to remove duplicate rows?

📘 View Explanation

Q11. What is normalization in DBMS?

📘 View Explanation

Q12. Which normal form removes partial dependency?

📘 View Explanation

Q13. Which operator is used with WHERE clause to filter patterns?

📘 View Explanation

Q14. What does SQL stand for?

📘 View Explanation

Q15. Which SQL function is used to count number of rows?

📘 View Explanation

Q16. Which clause is used in SQL to sort data?

📘 View Explanation

Q17. Which SQL clause groups rows based on common values?

📘 View Explanation

Q18. Which SQL keyword is used to remove a table permanently?

📘 View Explanation

Q19. Which command is used to change existing data in SQL?

📘 View Explanation

Q20. Which of the following is a DBMS software?

📘 View Explanation