GATEverse Practice, past papers & mock tests
GATE 2027: 115 days Sign in Create account
GATE 2025 · session-5
Database Management and WarehousingData Warehouse ModellingmediumMCQ2 marks
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? \[ SELECT D1, D2, sum(val) \] \[ FROM Facts \] \[ GROUP BY CUBE (D1, D2); \]
Save your progress

Related Database Management and Warehousing PYQs

GATE 2025 · session-5

If a relational decomposition is not dependency-preserving, which one of the following relational operators will be executed more …

GATE 2025 · session-5

Consider the following three relations: Car (model, year, serial, color) Make (maker, model) Own (owner, serial) A tuple in Car re…

GATE 2025 · session-5

On a relation named Loan of a bank: The following SQL query is executed: SELECT L1.loan_number FROM Loan L1 WHERE L1.amount \(>\) …

GATE 2025 · session-5

Consider the following two relations, named Customer and Person, in a database: Which of the following statements is/are correct?

GATE 2025 · session-5

Consider a database relation \( R \) with attributes \( A, B, C, D, E, F, G \), and having the following functional dependencies: …

GATE 2025 · session-5

Consider the following tables of a bank. | Loan number | Branch name | Amount | | --- | --- | --- | | L11 | Banjara Hills | 90000…