🗄️
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 4 of 5 • Questions 31-40 of 50
Q31medium
What is a partial dependency?
Q32easy
What is the main purpose of the COUNT(*) function?
Q33medium
What is the main advantage of hash index?
Q34medium
What is the main purpose of the SAVEPOINT statement?
Q35easy
What is the main difference between INNER JOIN and OUTER JOIN?
Q36easy
What is the main purpose of the GRANT statement?
Q37medium
What is a transitive dependency?
Q38easy
What is the main purpose of the ALTER TABLE statement?
Q39easy
What is the main purpose of the REVOKE statement?
Q40medium
What is the main advantage of B-tree index?
...