GATE CSE · Computer Science and Information Technology
ER model and relational model; integrity constraints and normal forms; file organisation and indexing; transactions and concurrency control.
Test yourself on Databases
5 real GATE CSE questions with instant answers — no signup, ~3 minutes.
Study notes are still being prepared.
Don't wait — Shishya can teach you this topic right now, on demand.
Ask Shishya to teach this →Shishya is your personal tutor for this topic. Pick a starter or open a free chat.
Q1 · Databases · MEDIUM
Consider a relation R(A, B, C, D) with functional dependencies F = {A → B, B → C, C → D}. What is the highest normal form that R satisfies?
Q2 · Databases · EASY
In a database, a transaction T₁ reads data item X, and before T₁ commits, another transaction T₂ modifies X and commits. If T₁ then reads X again, it sees a different value. Which isolation level does NOT prevent this anomaly?
Q3 · Databases · MEDIUM
A relation R(A, B, C, D, E) has functional dependencies: AB → C, C → D, D → E, E → A. What is the highest normal form of relation R?
Q4 · Databases · EASY
Consider a relation Student(ID, Name, Dept) with 500 tuples and Department(Dept, Building) with 20 tuples. If a natural join is performed on Dept attribute and every student belongs to exactly one department that exists in Department relation, what is the minimum possible number of tuples in the result?
Q5 · Databases · MEDIUM
Consider a relational schema R(A, B, C, D, E) with functional dependencies F = {A → B, BC → E, D → A}. Which of the following is a candidate key for R?