How to use the DBMS MCQ Quiz
- 1. Pick the lengthChoose 10 DBMS questions or all 21, with shuffle on or off.
- 2. Answer each questionTap an option to see at once if it is right, plus a short DBMS explanation.
- 3. See your scoreFinish to get your DBMS score and a review of all your answers.
What this quiz covers
DBMS is asked in almost every IT placement test. This quiz covers the topics that come up most:
- Keys: primary, foreign and candidate keys.
- Normalisation: 1NF, 2NF and 3NF and what each one removes.
- Transactions: ACID properties, COMMIT and ROLLBACK, and deadlocks.
- SQL groups: DDL, DML and DCL, DELETE vs TRUNCATE, HAVING and aggregates.
- Design: ER diagram symbols, weak entities and many-to-many relationships.
- Performance and types: indexes, views and NoSQL databases.
Worked example and how to use it
Example: Which normal form removes partial dependencies? The answer is 2NF. A partial dependency is when a non-key attribute depends on only part of a composite key. In a table with key (student_id, course_id), if student_name depends only on student_id, that is a partial dependency. Moving student_name into a separate students table fixes it.
Then 3NF goes further and removes transitive dependencies, where a non-key attribute depends on another non-key attribute, such as city depending on pincode.
To practise these ideas hands-on:
- Find keys and the highest normal form of any relation with the candidate key finder.
- Draw a schema with the ER diagram tool.
- Run real queries in the SQL online compiler, which has a ready sample database to explore.
Frequently asked questions
Is this the same as the SQL quiz?
No. This one is about database concepts. The SQL quiz focuses on writing and reading queries.
Does it cover BCNF?
The quiz covers 1NF to 3NF. The candidate key finder tool can check BCNF for any relation you enter.
Is it suitable for GATE?
It covers the basics GATE builds on, but GATE questions are usually deeper and numerical.
Is it free?
Yes, it is free. You only give your name and WhatsApp number once, when you see your final score, and then every Uncodemy tool stays open.