🗄️
GATE CS - Databases (DBMS)
Practice ER model, normalization, SQL queries, transactions, and indexing
50 questions•5 pages•~75 min
Use this quiz track to strengthen recall, speed, and exam-style decision making. Attempt one page first, review explanations, and then re-attempt incorrect questions without notes.
A good scoring strategy is to mark uncertain questions, finish known ones quickly, and return with elimination logic. This improves accuracy while keeping momentum under time constraints.
Progress: 0 / 500%
Page 2 of 5 • Questions 11-20 of 50
Q11easy
What is the minimum number of attributes in a candidate key?
Q12medium
What is the main difference between 2NF and 3NF?
Q13easy
What is the main purpose of the HAVING clause in SQL?
Q14easy
What is a dirty read?
Q15easy
What is the main advantage of INNER JOIN over CROSS JOIN?
Q16easy
What is the main purpose of the COMMIT statement?
Q17easy
What is the main difference between LEFT JOIN and INNER JOIN?
Q18easy
What is the main purpose of an index?
Q19medium
What is the main disadvantage of normalization?
Q20easy
What is the main purpose of the ROLLBACK statement?
...