GATE DA 2025 — Question 46

Database Management and Warehousingdata warehouse modelling: schema for multidimensional data models, concept hierarchies, measures: categorization and computationsMCQ2 marks · −2/3 if wrongMedium

Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute. Suppose attribute D1 takes 3 values and D2 takes 2 values, and all combinations of these values are present in the table Facts. How many tuples are there in the result of the following query?
sql
1SELECT D1, D2, sum(val)
2FROM Facts
3GROUP BY CUBE (D1, D2);
4
  1. A
    1
  2. B
    6
  3. C
    9
  4. D
    12
Practise the full 2025 paper
Challenge a friend: WhatsApp Telegram
From RENYXERAThis week's 10-question challengeSame 10 past-GATE questions for everyone this week — see where you stand.
Practise more on data warehouse modelling: schema for multidimensional data models, concept hierarchies, measures: categorization and computationsTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group