Consider the following relations P(X,Y,Z),Q(X,Y,T) and R(Y,V). P X Y Z X1 Y1 Z1 X1 Y1 Z2 X2 Y2 Z2 X2 Y4 Z4 Q X Y T X2 Y1 2 X1 Y2 5 X1 Y1 6 X3 Y3 1 R Y V Y1 V1 Y3 V2 Y2 V3 Y2 V2 How many tuples will be returned by the following relational algebra query? Π x ( σ ( P , Y = R . Y ∧ R . V = v 2 ) ( P × R ) ) − Π x ( σ ( Q , Y = R . Y ∧ Q . T > 2 ) ( Q × R ) ) __________.

Test Index

GATE Computer Science (CS) 2019 Solved Papers

Question : 65

Total: 65

__________.

Go to Question:

Prev Question