GATE | GATE 2017 MOCK II | Question 55

A student relation with 4 attributes is defines as R(ABCD). Which of the following query will execute without error if all attributes are numeric.

A)B,CA>20)
B) σA>20(∏B,C)
(A) Only A
(B) Only B
(C) Both
(D) None


Answer: (A)

Explanation: Query in A is correct. It will first select required rows and then project required columns. But query in B is not correct as after projecting B and C columns, it can’t have row selection based on condition on attribute A. So correct option is 1.

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.