GATE DA 2026 Q43: Number of cuboids from three concept hierarchies
- Database Management and Warehousing
- 2 marks
- MCQ
- −2/3 if wrong
Question
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?
Try it: multiple choice: exactly one correct option
Wrong answer costs 2/3 mark in GATE.
Show answer and explanation
Answer: A (official GATE 2026 final answer key)
Concept used: With hierarchies, total cuboids , where is the number of levels of dimension (the is "all").
First step: Each dimension has 3 levels plus "all", so 4 choices for each of the 3 dimensions.
Full step-by-step solution
Detailed working, common mistakes and linked mock tests will be available with a free GATEiit account. Log-in is coming soon.
Share this question
Source: official GATE 2026 DA question paper and final answer key, organised by IIT Guwahati. Question paper · Answer key
More Database Management and Warehousing PYQs
- 2026 · Q17Candidate keys from functional dependencies
- 2026 · Q18OLAP operation from Country to State
- 2026 · Q26Operations that never violate a foreign key
- 2026 · Q32Order of a B+ tree non-leaf node
- 2026 · Q41B+ tree root after inserting 3
- 2026 · Q42Output of a relational algebra expression with natural joins