DBMS MCQs
Solved DBMS MCQs from the KnowledgeGate question bank: normalization, SQL, transactions.
19 articles in this topic
Cardinalities, Participation and Entity Strength MCQs: 12 Solved DBMS Questions
Solve 12 DBMS MCQs on relationship cardinality, participation constraints and weak entities. Each answer includes the deciding ER-model rule.
Boyce-Codd Normal Form (BCNF) MCQs: 10 Solved Questions with Explanations
Solve 10 BCNF MCQs from GATE, UGC NET and DSSSB papers with clear reasoning on superkeys, candidate-key closures, 3NF exceptions and decomposition trade-offs.
Transaction States in DBMS MCQs: 11 Solved Questions with Explanations
Solve 11 practice MCQs on DBMS transaction states. Each answer explains the state, transition or recovery rule you need to apply.
DBMS Concurrency Problems MCQs: 10 Solved Questions with Explanations
Ten DBMS concurrency questions with worked values, operation orders, lock rules and concise explanations.
DBMS Transaction MCQs: 12 solved questions on ACID, serializability and locking
DBMS transaction MCQs with full solutions: 12 solved GATE and ISRO questions on ACID properties, conflict serializability, recoverability and 2PL locking.
DBMS SQL Query MCQs: 12 solved questions on SELECT, joins and subqueries
DBMS SQL query MCQs: 12 solved previous-year questions on SELECT and DISTINCT, inner and outer joins, GROUP BY and HAVING, and correlated subqueries.
DBMS Normalization MCQs: 12 solved questions from 1NF to BCNF (GATE/NET)
DBMS normalization MCQs: 12 solved previous-year questions from GATE, UGC NET, DSSSB and TPSC papers on 1NF, 2NF, 3NF, BCNF and lossless join decomposition.