GATE | GATE CS 2008 | Question 68

1) 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?

(A) Only I and II
(B) Only I and III
(C) Only I, II and III
(D) Only I, III and IV


Answer: (D)

Explanation: See Question 1 of http://www.geeksforgeeks.org/database-management-systems-set-7/

Quiz of this Question



My Personal Notes arrow_drop_up


Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.