Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like 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

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!