IBM Exam Questions

Which set operators can be used to produce a result data set that contains only records that are not

Given the following queries:
SELECT c1 FROM tab1;

SELECT c1 FROM tab2;
Which 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

Explanation: