Which of the following is/are correct?

1999

Which of the following is/are correct?

Answer: D. None of the above — SQL SELECT statements return all rows by default, including duplicates. To eliminate duplicate rows from the result set, you must explicitly use the DISTINCT…

  1. A.

    An SQL query automatically eliminates the duplicates

  2. B.

    An SQL query will not work if there are no indexes on the relations

  3. C.

    SQL permits attribute names to be repeated in the same relation

  4. D.

    None of the above

Attempted by 355 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.

Explore the full course: Iocl Engineers Officers Grade A Paper 2

Loading lesson…