Gate CS-2009 Question Paper With Solutions

Q. 24 Let R and S be relation schemes such that R = {a,b,c} and S = {c}. Now consider
the following queries on the database :
Gate CS-2009 Question Paper With Solutions

IV) SELECT R.a, R.b
       FROM R,S
            WHERE R.c=S.c

Which of the above queries are equivalent?

(A) I and II

(B) I and III

(C) II and IV

(C) III and IV

Answer: (A)

Explanation:

Gate CS-2009 Question Paper With Solutions

Learn More:   Gate EE-2004 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here