1
GATE CSE 2026 Set 1
MCQ (More than One Correct Answer)
+1
-0

In the context of relational database normalization, which of the following statements is/ are true?

A

It is always possible to obtain a dependency-preserving 3NF decomposition of a relation

B

It is always possible to obtain a dependency-preserving 1NF decomposition of a relation

C

It is not always possible to obtain a dependency-preserving BCNF decomposition of a relation

D

It is not always possible to obtain a dependency-preserving 2NF decomposition of a relation

2
GATE CSE 2026 Set 1
MCQ (Single Correct Answer)
+2
-0

Consider a relational database schema with two relations $R(P, Q)$ and $S(X, Y)$.

Let $E=\{\langle u\rangle \mid \exists v \exists w\langle u, v\rangle \in R \wedge\langle v, w\rangle \in S\}$ be a tuple relational calculus expression. Which one of the following relational algebraic expressions is equivalent to $E$ ?

A

$\Pi_P\left(R \bowtie_{R . P=S . X} S\right)$

B

$\Pi_P\left(S \bowtie_{S . X=R . Q} R\right)$

C

$\Pi_P\left(R \bowtie_{R . P=S . Y} S\right)$

D

$\Pi_P\left(S \bowtie_{S . Y=R . Q} R\right)$

3
GATE CSE 2026 Set 1
Numerical
+2
-0
Consider a relational database schema with a relation $R(A, B, C, D)$. If $\{A, B\}$ and $\{A, C\}$ are the only two candidate keys of the relation $R$, then the number of superkeys of relation $R$ is $\_\_\_\_$ . (answer in integer)
Your input ____
4
GATE CSE 2026 Set 1
MCQ (More than One Correct Answer)
+1
-0

Consider the following Boolean expression of a function $F$ :

$$ F(P, Q)=(\bar{P}+Q) \oplus(\bar{P} Q) $$

Which of the following expressions is/are equivalent to $F$ ?

A

$\overline{P \oplus Q}$

B

$P \oplus Q$

C

$\bar{P} \oplus Q$

D

$\bar{P} \oplus \bar{Q}$