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);

Consider the following two relations, named Customer and Person, in a

database:

Person (

aadhaar CHAR(12) PRIMARY KEY, name VARCHAR(32));

Customer (

name VARCHAR(32), email VARCHAR(32) PRIMARY KEY, phone CHAR(10), aadhaar CHAR(12), FOREIGN KEY (aadhaar) REFERENCES Person(aadhaar)); Which of the following statements is/are correct?

Consider a database relation $R$ with attributes ABCDEFG , and having the following functional dependencies:

$$ \mathrm{A} \rightarrow \mathrm{BCEF} \quad \mathrm{E} \rightarrow \mathrm{DG} \quad \mathrm{BC} \rightarrow \mathrm{~A} $$

Which of the following statements is/are correct?

Consider the following tables, Loan and Borrower, of a bank.

Query: $\quad \pi_{\text {branch_name, customer_name }}$ (Loan $\triangleright \triangleleft$

Borrower) $\div \pi_{\text {branch_name }}$ (Loan)

where $\triangleright \triangleleft$ denotes natural join.

The number of tuples returned by the above relational algebra query is

__________