1
GATE AI 2025
MCQ (More than One Correct Answer)
+2
-0

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?

A
A is the only candidate key of R
B
A, BC are the candidate keys of R
C
A, BC, E are the candidate keys of R
D
Relation R is not in Boyce-Codd Normal Form (BCNF)
2
GATE AI 2025
Numerical
+2
-0

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

Loan
loan_num branch_name amount
L11 Banjara Hills 90000
L14 Kondapur 50000
L15 SR Nagar 40000
L22 SR Nagar 25000
L23 Balanagar 80000
L25 Kondapur 70000
L19 SR Nagar 65000
Borrower
customer_name loan_num
Anand L11
Karteek L11
Karteek L14
Ankita L15
Gopal L19
Karteek L22
Karteek L23
Sunil L23
Sunil L25

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

__________

Your input ____
3
GATE AI 2025
MCQ (Single Correct Answer)
+1
-0

Suppose $X$ and $Y$ are random variables. The conditional expectation of $X$ given $Y$ is denoted by $E[X \mid Y]$. Then $E[E[X \mid Y]]$ equals

A
$E[X \mid Y]$
B
$\frac{E[X]}{E[Y]}$
C
$E[X]$
D
$E[Y]$
4
GATE AI 2025
MCQ (Single Correct Answer)
+1
-0

The sum of the elements in each row of $A \in \mathbb{R}^{n \times n}$ is 1 . If $B=A^3-2 A^2+A$, which one of the following statements is correct (for $x \in \mathbb{R}^n$ )?

A
The equation $B x=0$ has no solution
B
The equation $B x=0$ has exactly two solutions
C
The equation $B x=0$ has infinitely many solutions
D
The equation $B x=0$ has a unique solution

GATE Data Science and Artificial Intelligence Papers

All year-wise previous year question papers