The ____ set operator returns distinct rows from both queries.
A) UNION ALL
B) INTERSECT
C) MINUS
D) DISTINCT

Question

Quizplus · Accepted Answer

The INTERSECT operator returns distinct rows that are present in both queries, unlike UNION ALL which combines all rows including duplicates. MINUS returns distinct rows from the first query that are not present in the second query. DISTINCT is not a set operator but a keyword used to remove duplicate rows from a single query result.

The ____ Set Operator Returns Distinct Rows from Both Queries