GATE CSE · Computer Science and Information Technology
Databases
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 →Need more? Ask Shishya
Shishya is your personal tutor for this topic. Pick a starter or open a free chat.
- Go deeper on this topicGo deeper on Databases for GATE CSE — examples and edge cases I should know.
- Show me exam shortcutsGive me 3 fastest shortcuts to solve Databases questions in the exam.
- What mistakes should I avoid?What are the most common mistakes students make on Databases? How do I avoid them?
- Quiz me adaptivelyQuiz me on Databases — start with one easy question, then go harder based on how I answer.
Practice this topic
Take a full mock →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?