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
Recommended book · affiliate linkDatabase System Concepts (Korth)Normalisation, SQL, transactions and indexing — the DBMS syllabus in one book.
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