Multiple choice sql

The result of a SELECT statement can contain duplicate rows.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SELECT statements return all matching rows by default, including duplicates. DISTINCT must be explicitly used to remove duplicate rows.

AI explanation

Unless a SELECT DISTINCT clause is used, SQL does not automatically remove duplicate rows from a result set — if the underlying data (or a join) produces identical rows, they will all be returned. Deduplication only happens when it's explicitly requested, so the statement that duplicates can appear is true.

Keep practicing — related questions