Related Articles

Related Articles

GATE | GATE-CS-2009 | Question 60
  • Difficulty Level : Expert
  • Last Updated : 24 Jan, 2014

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?
(A) I and II
(B) I and III
(C) II and IV
(D) III and IV


Answer: (A)

Explanation: I and II describe the division operator in Relational Algebra and Tuple Relational Calculus respectively. See Page 3 of this and slide numbers 9,10 of this for more details.

Quiz of this Question

sudo-gate-course

My Personal Notes arrow_drop_up
Recommended Articles
Page :