1
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)$

2
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 ____
3
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}$

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

Consider the 8-bit signed integers $X, Y$ and $Z$ represented using the sign-magnitude form. The binary representations of $X$ and $Y$ are as follows:

$$ X: 10110100 \quad Y: 01001100 $$

Which of the following operations to compute $Z$ result(s) in an arithmetic overflow?

A

$Z=X+Y$

B

$Z=X-Y$

C

$Z=-X+Y$

D

$Z=-X-Y$