GATEverse Practice, past papers & mock tests
GATE 2027: 115 days Sign in Create account
GATE 2026 · session-8
Database Management and WarehousingTuple CalculusmediumNAT2 marks
Let there be two relations \(X\) and \(Y\) as shown. \(X\) has three columns \(P\), \(Q\) and \(R\). \(Y\) has two columns \(P\) and \(S\). Relation X:
PQR
P1Q1R1
P2Q2R2
P3Q3R2
Relation Y:
PS
P110
P115
P220
P31
Consider that the following tuple relational calculus expression is evaluated. \[ \{t \mid t \in X \wedge \exists z \in X (t[P] = z[P]) \wedge \exists m \in Y (m[P] = t[P] \wedge m[S] > 1)\} \] The number of tuples that will be returned is _______. (Answer in integer)
Save your progress

Related Database Management and Warehousing PYQs

GATE 2026 · session-8

Let \(R(A,B,C,D,E)\) be a relational schema with functional dependency set \(F = \{A \rightarrow BC,\ CD \rightarrow E,\ E \righta…

GATE 2026 · session-8

Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each combination of the attributes Prod…

GATE 2026 · session-8

Consider two relations \(r\) and \(s\) defined on the relational schemas \(R(A,B)\) and \(S(E,C)\), respectively. \(A\) is the pri…

GATE 2026 · session-8

In a relational database, a B+ Tree Index is to be constructed for a relation on a key field. In a B+ Tree, a Node Pointer points …

GATE 2026 · session-8

Consider a B+ Tree where the maximum number of key values in each leaf node is 2 and the maximum number of pointers in each non-le…

GATE 2026 · session-8

Consider the given relations \(X\), \(Y\) and \(Z\). The relation \(X\) has three columns P, Q and R. The relation \(Y\) has three…