GATE 2008 CS – Question 68
Relations R(P, Q, R1, R2, R3), S(P, Q, S1, S2) both have key {P, Q}. Which queries are equivalent?
I. $\pi_P(R\bowtie S)$
II. $\pi_P(R)\bowtie\pi_P(S)$
III. $\pi_P(\pi_{P,Q}(R)\cap\pi_{P,Q}(S))$
IV. $\pi_P(\pi_{P,Q}(R)-(\pi_{P,Q}(R)-\pi_{P,Q}(S)))$
Practise this question in The GATE Grind →
Show answer and explanation
Correct answer: (D) Only I, III and IV
Explanation
We are sorry we couldn't write detailed soluition for this, we are working on it!, please consider asking your own AI, its just 2-3 clicks with very minimum effort
More Relational Model: Relational Algebra, Tuple Calculus, SQL questions
- GATE 2007 CS Q59
- GATE 2007 CS Q60
- GATE 2007 CS Q61
- GATE 2026 CS (CS1) Q30
- GATE 2026 CS (CS1) Q43
- GATE 2025 CS (CS1) Q39
All Relational Model: Relational Algebra, Tuple Calculus, SQL questions →