IBM Exam Questions

Which of the following set operators can be used to produce a result data set that contains only rec

Given the following queries:
SELECT c1 FROM tab1;
SELECT c1 FROM tab2;
Which of the following set operators can be used to produce a result data set that contains only
records that are not found in the result data set produced by each query after duplicate rows have
been eliminated?

A.
UNION

B.
INTERSECT

C.
EXCEPT

D.
MERGE