Question

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

A) True
B) False

Answer 1

The statement is true; the UNION keyword in SQL suppresses duplicate rows when combining results of two SELECT statements. To include duplicates, UNION ALL is used instead.

Step-by-step explanation:

When combining the results of two SELECT statements with the UNION keyword, the statement is indeed true: duplicate rows are suppressed in the results. The UNION operator by default selects only distinct values. However, if you wish to include all duplicates as well, you should use UNION ALL.