Which of the following is/are correct?
1999
Which of the following is/are correct?
- A.
An SQL query automatically eliminates 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 334 students.
Show answer & explanation
Correct answer: D
In standard SQL, duplicate rows are not automatically eliminated; the DISTINCT keyword must be explicitly specified. Queries can function without indexes, and attribute names within a table schema must remain unique. Consequently, the assertions in options A, B, and C are factually incorrect.
A video solution is available for this question — log in and enroll to watch it.