Question

When combining the results of two SELECT statements with the UNION keyword, duplicate rows are suppressed in the results.

a) INTERSECT
b) EXCEPT
c) DISTINCT
d) ALL

Answer 1

When combining the results of two SELECT statements with the UNION keyword, duplicate rows are suppressed in the results using the DISTINCT keyword.

Step-by-step explanation:

When combining the results of two SELECT statements with the UNION keyword, duplicate rows are suppressed in the results. The correct option is c) DISTINCT. The INTERSECT keyword returns only the rows that are common to both SELECT statements, whereas the EXCEPT keyword returns only the rows that are unique to the first SELECT statement. The keyword ALL can be used to include duplicate rows in the results.