Multiple choice technology programming languages

Following SQL operator will allow duplicates

  1. UNION ALL

  2. UNION

  3. INTERSECT

  4. MINUS
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

UNION ALL allows duplicates by combining all rows from both datasets without removing duplicates. UNION removes duplicates, INTERSECT finds common rows, and MINUS finds rows in one dataset but not the other.

Keep practicing — related questions