DBMS and Data Warehousing GATE DA PYQ: Topic-wise Questions

DBMS and Data Warehousing GATE DA PYQs: all 23 questions from 3 official papers (2024–2026), by concept with official answers. Asked in 3 of 3 years.

Updated2 min read

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.

YearQuestionsMarks
GATE DA 20261118
GATE DA 2025711
GATE DA 202457

Most-asked concepts

Sorted by the number of papers a concept appeared in.

ConceptQuestionsPapersYears
Normalization and Functional Dependencies432026, 2025, 2024
Relational Algebra432026, 2025, 2024
SQL432026, 2025, 2024
Data Warehousing322026, 2025
Indexing and File Organization322026, 2024
Integrity Constraints222026, 2025
Data Transformation112024
ER Model112026
Tuple Calculus112026

How to practise Database Management and Warehousing PYQs

  1. Start with the concepts at the top of the table. They have come back the most.
  2. Solve one year’s Database Management and Warehousing questions from the official PDF against the clock, then check the answer listed below.
  3. For each mistake, note whether you didn’t know the concept, slipped on a calculation or misread the question. Each needs a different fix.
  4. 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

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.