GATE Papers >> CSE >> 2008 >> Question No 68

Question No. 68 CSE | GATE 2008

Let R and S be two relations with the following schema
R (P,Q.R1,R2,R3)
S (P,Q,S1,S2)
Where {P, Q} is the key for both schemas. Which of the following queries are equivalent?

I. p (R $\bowtie$ S)
II. p (R) $\bowtie$ p (S)
III. p (p, Q (R) p, Q (S))
IV. p (p, Q (R) - (p, Q (R) - p, Q (S))

Answer : (D) Only I , III and IV

No Comments
Leave a comment