Explore: All GATE DA topics · GATE DA Data Science and Artificial Intelligence PYQs · GATE DA hub · Syllabus & pattern · GATE DA 2026
How often Database Management and Warehousing is asked
In the 3 official GATE DA papers we tagged (2024–2026), Database Management and Warehousing (Data Science and Artificial Intelligence) had 23 questions, appearing in 3 of them. Asked in 3 of 3 years. Weightage: 12 marks a year on average (7–18), about 12% of a 100-mark paper. The concepts asked in the most papers: Normalization and Functional Dependencies, Relational Algebra, SQL.
Year-wise question count
Asked in 3 of 3 years.
| Year | Questions | Marks |
|---|---|---|
| GATE DA 2026 | 11 | 18 |
| GATE DA 2025 | 7 | 11 |
| GATE DA 2024 | 5 | 7 |
Most-asked concepts
Sorted by the number of papers a concept appeared in.
| Concept | Questions | Papers | Years |
|---|---|---|---|
| Normalization and Functional Dependencies | 4 | 3 | 2026, 2025, 2024 |
| Relational Algebra | 4 | 3 | 2026, 2025, 2024 |
| SQL | 4 | 3 | 2026, 2025, 2024 |
| Data Warehousing | 3 | 2 | 2026, 2025 |
| Indexing and File Organization | 3 | 2 | 2026, 2024 |
| Integrity Constraints | 2 | 2 | 2026, 2025 |
| Data Transformation | 1 | 1 | 2024 |
| ER Model | 1 | 1 | 2026 |
| Tuple Calculus | 1 | 1 | 2026 |
How to practise Database Management and Warehousing PYQs
- Start with the concepts at the top of the table. They have come back the most.
- Solve one year’s Database Management and Warehousing questions from the official PDF against the clock, then check the answer listed below.
- For each mistake, note whether you didn’t know the concept, slipped on a calculation or misread the question. Each needs a different fix.
- Once a concept is clean in two papers, move to the next. Then sit a full paper from the year pages.
Questions by year
Each line gives the question number, type, concept, our one-line summary and the official answer, with a link to the official PDF.
GATE DA 2026
- Q.17 · MCQ · 1 mark · Normalization and Functional Dependencies: Candidate keys of a relation from its functional dependencies (official answer: A) PDF
- Q.18 · MCQ · 1 mark · Data Warehousing: OLAP operation to move from country level to state level (official answer: D) PDF
- Q.26 · MSQ · 1 mark · Integrity Constraints: Operations that never violate a foreign key constraint (official answer: A, B) PDF
- Q.32 · NAT · 1 mark · Indexing and File Organization: Maximum node pointers in a non-leaf node of a B+ tree (official answer: 195) PDF
- Q.41 · MCQ · 2 marks · Indexing and File Organization: Root keys of a B+ tree after inserting a key (official answer: A) PDF
- Q.42 · MCQ · 2 marks · Relational Algebra: Output of a relational algebra expression with joins and selections (official answer: D) PDF
- Q.43 · MCQ · 2 marks · Data Warehousing: Number of data cuboids from given concept hierarchies (official answer: A) PDF
- Q.51 · MSQ · 2 marks · SQL: SQL queries that report each employee team size (official answer: A) PDF
- Q.59 · NAT · 2 marks · Tuple Calculus: Tuples returned by a tuple relational calculus expression (official answer: 2–3) PDF
- Q.60 · NAT · 2 marks · SQL: Rows returned by a correlated SQL query comparing balance counts (official answer: 3) PDF
- Q.61 · NAT · 2 marks · ER Model: Minimum 3NF relations for an ER model with a multivalued attribute (official answer: 4) PDF
GATE DA 2025
- Q.16 · MCQ · 1 mark · Normalization and Functional Dependencies: Operator needed more often when a decomposition is not dependency-preserving (official answer: C) PDF
- Q.17 · MCQ · 1 mark · Relational Algebra: Meaning of a relational algebra query over car, make and owner relations (official answer: C) PDF
- Q.33 · NAT · 1 mark · SQL: Rows returned by a nested query comparing amounts with a branch maximum (official answer: 3) PDF
- Q.46 · MCQ · 2 marks · Data Warehousing: Number of tuples from a GROUP BY CUBE query on a fact table (official answer: D) PDF
- Q.56 · MSQ · 2 marks · Integrity Constraints: Key, null and foreign key facts for two SQL table definitions (official answer: B, C) PDF
- Q.57 · MSQ · 2 marks · Normalization and Functional Dependencies: Candidate keys and BCNF status from functional dependencies (official answer: B, D) PDF
- Q.62 · NAT · 2 marks · Relational Algebra: Tuples returned by a relational division query on loan tables (official answer: 1) PDF
GATE DA 2024
- Q.26 · MCQ · 1 mark · Relational Algebra: Relational algebra check that every team name is a defender or forward (official answer: C) PDF
- Q.27 · MCQ · 1 mark · Data Transformation: Z-score normalised value of an income attribute (official answer: B) PDF
- Q.31 · NAT · 1 mark · SQL: Rows returned by a join query with city and points filters (official answer: 3) PDF
- Q.46 · MSQ · 2 marks · Normalization and Functional Dependencies: Functional dependencies derivable from a given set (official answer: A, B, D) PDF
- Q.55 · MSQ · 2 marks · Indexing and File Organization: Indexes that speed up a three-table SQL join query (official answer: A, B) PDF
Other Data Science and Artificial Intelligence topics
- Probability and Statistics PYQs
- Linear Algebra PYQs
- Calculus and Optimization PYQs
- Programming, Data Structures and Algorithms PYQs
- Machine Learning PYQs
- Artificial Intelligence PYQs
FAQ
How many Database Management and Warehousing questions come in GATE DA?
In the official papers we tagged: 11 in 2026, 7 in 2025 and 5 in 2024. That is 23 questions in all, about 14% of Data Science and Artificial Intelligence. Weightage: 12 marks a year on average (7–18), about 12% of a 100-mark paper.
Which Database Management and Warehousing topics repeat in GATE DA?
Asked in the most papers: Normalization and Functional Dependencies, Relational Algebra, SQL. The concept table lists every one with its count.
Are these official GATE DA questions?
Yes. Every question is from an official GATE DA paper hosted on our year pages. The one-line summaries are ours; open the PDF linked beside each question for the full text.