Let R and S be relational schemes such that R={a,b,c} and S={c}. Now consider…

GATE · 2009 · CS

Let R and S be relational schemes such that R={a,b,c} and S={c}. Now consider the following queries on the database:

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

Which of the above queries are equivalent?

  1. A.

    I and II

  2. B.

    I and III

  3. C.

    II and IV

  4. D.

    III and IV

Attempted by 130 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…