GATE DA 2026 — Question 42

Database Management and Warehousingrelational model: relational algebra, tuple calculus, SQLMCQ2 marks · −2/3 if wrongMedium

Consider the given relations \(X\), \(Y\) and \(Z\). The relation \(X\) has three columns \(P\), \(Q\) and \(R\). The relation \(Y\) has three columns \(P\), \(Q\) and \(S\). The relation \(Z\) has two columns \(P\) and \(T\).
Question image
Consider the relational algebra expression
\[\prod_{PRS}\left[\left(\sigma_{(Q = Q3 \vee R = R2)}[X \bowtie Y]\right) \bowtie \left(\sigma_{(S > 1)}[Y \bowtie Z]\right)\right]\]
where \(\bowtie\) denotes natural join operation. Which of the following options is the correct output for the given expression?
  1. A
    Two rows (P1, R1, 2) and (P1, R1, 5)
  2. B
    Three rows (P1, R1, 2), (P1, R1, 5) and (P2, R2, 6)
  3. C
    One row (P1, R1, 2)
  4. D
    Zero rows
Practise the full 2026 paper
Challenge a friend: WhatsApp Telegram
From RENYXERAThis week's 10-question challengeSame 10 past-GATE questions for everyone this week — see where you stand.
Practise more on relational model: relational algebra, tuple calculus, SQLTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group