GATE | GATE CS 1999 | Question 50
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
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.