chapter

Database Management and Warehousing PYQs for GATE DA

GATE DA Database Management and Warehousing: 2 units and 6 chapters, weightage from 22 previous year questions across 3 papers, a study order by exam weight a

A question from this chapter

Question 1

2026 PYQ

Let Account be a relation as shown. Account AccNo Balance A1 5000 A2 5000 A3 10000 A4 15000 A5 18000 Consider the given SQL query. SELECT AccNo FROM Account AS A WHERE (SELECT COUNT(*) FROM Account AS B WHERE A.Balance < B.Balance) >= (SELECT COUNT(*) FROM Account AS C WHERE A.Balance > C.Balance) The number of rows returned by the SQL query is __________ . (Answer in integer)

Question 2

2026 PYQ

Consider an ER model with the entities E_{1} (A_{11}, A_{12}, A_{13}) and E_{2} (A_{21}, A_{22}, A_{23}), where, A_{11}, A_{12}, A_{13} are the attributes of E_{1}, and A_{21}, A_{22}, A_{23} are the attributes of E_{2} . Let A_{22} be a multi-valued attribute. A_{11} and A_{21} are the primary keys of E_{1} and E_{2}, respectively. Let R_{12} be a many-to-many relationship between E_{1} and E_{2} . Participation of both E_{1} and E_{2} in R_{12} is total. The minimum number of relations required to convert the ER model into relational model (assuming there is no other functional dependency) where each relation is in third normal form (3NF) is __________ . (Answer in integer)

Question 3

2026 PYQ

Let R(A,B,C,D,E) be a relational schema with functional dependency set F = {A \to B C, C D \to E, E \to A} . Which of the following statements is correct?

Question 4

2026 PYQ

In a relational database, a B+ Tree Index is to be constructed for a relation on a key field. In a B+ Tree, a Node Pointer points to a sub-tree and a Data Record Pointer points to a block of database records. Let, Node size = 4096 bytes, Node Pointer size = 10 bytes, Search Key Field size = 11 bytes and Data Record Pointer size = 12 bytes. The maximum number of Node Pointers that can be present in a non-leaf node of the B+ Tree is ________ . (Answer in integer)

Question 5

2026 PYQ

Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each combination of the attributes Product Type, Month and Country. From this, if we want to further visualize the Sales Quantity for each combination of Product Type, Month and State, which of the following OLAP operations should be performed?

Question 6

2026 PYQ

Consider the concept hierarchies as shown in the figure. Year Month Day Country State City Item Category Item Type Item Which of the following options denotes the total number of possible data cuboids from these concept hierarchies?

Free preview ends here

Login to view the complete previous-year questions and solutions

Creating an account is free. You get the rest of this chapter, step-by-step solutions, and a study plan built around the topics you are actually weak at.

Why MastersUp

Personalised first. High quality throughout.

Most platforms hand everyone the same content. Here the content moves with your performance, topic by topic.

Built around you, not around a syllabus PDF

Every answer you give moves your topic-level intelligence rate. The next question, the next revision card and tomorrow's plan all change with it.

Revision that hits your weak spots

We only revise topics you have actually attempted and are still below the safe bar on — never the same chapter on repeat.

Questions calibrated to the real exam

Each question carries a measured toughness. You are served a rung above your current level, so practice keeps stretching you.

Notes written for recall, not for volume

Full lesson cards for first study, curated short-note cards for the last mile — with derivations, traps and exam patterns marked.

One place for everything

Notes, chapter practice, previous-year questions, test series and full-length papers — all feeding one picture of your preparation.

Honest progress

No vanity streaks. Progress here means chapters mastered and accuracy that held up on harder questions.

Unlock the whole course

Full notes and short notes, the complete question bank with worked solutions, mock tests, full-length papers, and an adaptive plan that rebuilds itself as you improve.

View all plans Start free

Database Management and Warehousing PYQs for GATE DA

GATE DA Database Management and Warehousing: 2 units and 6 chapters, weightage from 22 previous year questions across 3 papers, a study order by exam weight and 0 practice questions.

About Database Management and Warehousing Previous Year Questions (PYQs)

22 previous year questions from Database Management and Warehousing in GATE DA, grouped by chapter with the exam year, answer key and step-by-step solution for each.

GATE DA Database Management and Warehousing Unit-wise Weightage from Past Papers

We counted every GATE DA Database Management and Warehousing previous year question in our bank (22 questions from 3 papers) and grouped them by unit.

Unit	Chapters	PYQs	Share of section	Avg per paper
Database Systems	4	19	86%	6.3
Data Warehousing	2	3	14%	1

Suggested Database Management and Warehousing Study Order for GATE DA

Database Systems: 86% of past Database Management and Warehousing questions, about 6.3 per paper.
Data Warehousing: 14% of past Database Management and Warehousing questions, about 1 per paper.

Start where the marks are. Units at the top of this list have appeared most often in past GATE DA papers.

Units in GATE DA Database Management and Warehousing

All Database Management and Warehousing chapters

One Solved Question from Each Database Management and Warehousing Chapter

Question 1 · Relational Algebra and SQL Queries · 2026 NAT

Let Account be a relation as shown.

Account
AccNo Balance
A1 5000
A2 5000
A3 10000
A4 15000
A5 18000

Consider the given SQL query.

SELECT AccNo FROM Account AS A
WHERE (SELECT COUNT(*) FROM Account AS B
WHERE A.Balance < B.Balance) >= (SELECT COUNT(*)
FROM Account AS C WHERE A.Balance > C.Balance)

The number of rows returned by the SQL query is __________ . (Answer in integer)

Question 2 · ER Model, Keys and Integrity Constraints · 2026 NAT

Consider an ER model with the entities

E_{1} (A_{11}, A_{12}, A_{13})

and

E_{2} (A_{21}, A_{22}, A_{23})

, where,

A_{11}, A_{12}, A_{13}

are the attributes of

E_{1}

, and

A_{21}, A_{22}, A_{23}

are the attributes of

E_{2}

. Let

A_{22}

be a multi-valued attribute.

A_{11}

and

A_{21}

are the primary keys of

E_{1}

and

E_{2}

, respectively.

Let

R_{12}

be a many-to-many relationship between

E_{1}

and

E_{2}

. Participation of both

E_{1}

and

E_{2}

R_{12}

is total.

The minimum number of relations required to convert the ER model into relational model (assuming there is no other functional dependency) where each relation is in third normal form (3NF) is __________ . (Answer in integer)

Question 3 · Functional Dependencies and Normalization · 2026 MCQ

Let R(A,B,C,D,E) be a relational schema with functional dependency set

F = {A \to B C, C D \to E, E \to A}

.
Which of the following statements is correct?

A.
AD, ED and CD are the only candidate keys of R.
B.
AD and ED are the only candidate keys of R.
C.
A, E and CD are the only candidate keys of R.
D.
A and CD are the only candidate keys of R.

Question 4 · Indexing and B+ Trees · 2026 NAT

In a relational database, a B+ Tree Index is to be constructed for a relation on a key field. In a B+ Tree, a Node Pointer points to a sub-tree and a Data Record Pointer points to a block of database records.

Let, Node size = 4096 bytes, Node Pointer size = 10 bytes, Search Key Field size = 11 bytes and Data Record Pointer size = 12 bytes.

The maximum number of Node Pointers that can be present in a non-leaf node of the B+ Tree is ________ . (Answer in integer)

Question 5 · OLAP Operations and Data Cube Aggregation · 2026 MCQ

Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each combination of the attributes Product Type, Month and Country.
From this, if we want to further visualize the Sales Quantity for each combination of Product Type, Month and State, which of the following OLAP operations should be performed?

A.
Slicing
B.
Dicing
C.
Roll-up
D.
Drill-down

Question 6 · Concept Hierarchies and Multidimensional Data Models · 2026 MCQ

Consider the concept hierarchies as shown in the figure.

Which of the following options denotes the total number of possible data cuboids from these concept hierarchies?

A.
$4^{3}$
B.
$2^{3}$
C.
$2!$
D.
$4!$