Which of the following is/are correct?
1999
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
Attempted by 63 students.
Show answer & explanation
Correct answer: D
SQL SELECT statements return all rows by default, including duplicates. To eliminate duplicate rows from the result set, you must explicitly use the DISTINCT keyword in your query.