Database Management Systems MCQ
Database Management Systems (DBMS) MCQ Questions are an excellent way to test your understanding of core database concepts. These multiple-choice questions cover topics such as database models, normalization, SQL commands, indexing, transactions, and security. Whether you are preparing for exams, interviews, or looking to strengthen your DBMS knowledge, these MCQs will help you assess and improve your skills. Perfect for beginners and advanced learners alike, these questions will provide a solid foundation in database management and prepare you for real-world applications.
Q1. What does DBMS stand for?
A. Database Management System
B. Data Basic Management System
C. Database Manipulation Software
D. Data Backup Management System
📘 View Explanation
Q2. Which of the following is an example of DBMS?
A. MS Word
B. MS Excel
C. Oracle
D. PowerPoint
📘 View Explanation
Q3. In DBMS, what is a table also called?
A. Attribute
B. Entity
C. Relation
D. Tuple
📘 View Explanation
Q4. What is a row in a database table called?
A. Tuple
B. Attribute
C. Entity
D. Field
📘 View Explanation
Q5. What is a column in a database table called?
A. Tuple
B. Attribute
C. Entity
D. Relation
📘 View Explanation
Q6. Which key uniquely identifies a row in a table?
A. Foreign Key
B. Primary Key
C. Candidate Key
D. Super Key
📘 View Explanation
Q7. What is a foreign key used for?
A. To uniquely identify records
B. To connect two tables
C. To create indexes
D. To store null values
📘 View Explanation
Q8. Which SQL command is used to extract data from a database?
A. INSERT
B. SELECT
C. UPDATE
D. DELETE
📘 View Explanation
Q9. Which SQL command is used to add new data?
A. INSERT
B. DELETE
C. SELECT
D. ALTER
📘 View Explanation
Q10. Which SQL keyword is used to remove duplicate rows?
A. UNIQUE
B. DISTINCT
C. REMOVE
D. DELETE
📘 View Explanation
Q11. What is normalization in DBMS?
A. Data compression
B. Removing redundancy
C. Adding redundancy
D. Indexing tables
📘 View Explanation
Q12. Which normal form removes partial dependency?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
📘 View Explanation
Q13. Which operator is used with WHERE clause to filter patterns?
A. LIKE
B. BETWEEN
C. IN
D. ALL
📘 View Explanation
Q14. What does SQL stand for?
A. Structured Query Language
B. Sequential Query Language
C. Simple Query Language
D. Standard Query Logic
📘 View Explanation
Q15. Which SQL function is used to count number of rows?
A. SUM()
B. COUNT()
C. ROWNUM()
D. TOTAL()
📘 View Explanation
Q16. Which clause is used in SQL to sort data?
A. ORDER BY
B. GROUP BY
C. SORT
D. RANK
📘 View Explanation
Q17. Which SQL clause groups rows based on common values?
A. ORDER BY
B. GROUP BY
C. HAVING
D. WHERE
📘 View Explanation
Q18. Which SQL keyword is used to remove a table permanently?
A. REMOVE
B. DELETE
C. DROP
D. TRUNCATE
📘 View Explanation
Q19. Which command is used to change existing data in SQL?
A. ALTER
B. UPDATE
C. MODIFY
D. INSERT
📘 View Explanation
Q20. Which of the following is a DBMS software?
A. MySQL
B. PostgreSQL
C. MongoDB
D. All of the above
📘 View Explanation