Skip to content
Related Articles

Related Articles

Improve Article

GATE | GATE CS 1999 | Question 50

  • Last Updated : 24 Oct, 2018

Which of the following is/are correct?
(A) An SQL query automatically eliminates the duplicates
(B) An SQL query will not work if there are no indexes on the relations
(C) SQL permits attribute names to be repeated in the same relation
(D) None of the above

Answer: (D)

Explanation: An SQL does not remove duplicates like relational algebra projection, we have to remove it using distinct.
An SQL will work slowly but surely if there are no indexes.
An SQL does not permit 2 attributes of same name in a relation.

So, none of the options (a), (b) and (c) are correct. Hence, option (d) is Answer.

Quiz of this Question

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up
Recommended Articles
Page :