Skip to content
Related Articles

Related Articles

GATE | GATE-CS-2009 | Question 60

Improve Article
Save Article
  • Difficulty Level : Expert
  • Last Updated : 28 Jun, 2021
Improve Article
Save Article

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

       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

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!