GATE CS 2019 (Forenoon) — Question 65

Database Management Systems (DBMS)Relational Models, Relational Algebra, Tuple CalculusNAT2 marksMedium

Consider the following relations P(X, Y, Z), Q(X, Y, T) and R(Y, V).
Question image
How many tuples will be returned by the following relational algebra query? \( \Pi_x (\sigma_{(P.Y = R.Y \land R.V = V2)} (P \times R)) - \Pi_x (\sigma_{(Q.Y = R.Y \land Q.T > 2)} (Q \times R)) \)
Practise the full 2019-FN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAWhat rank do your marks get?GATE score, likely All-India Rank and qualifying marks for your category.
Practise more on Relational Models, Relational Algebra, Tuple CalculusTimed, 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