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
MERGE
The MERGE statement updates a target (a table or view, or the underlying tables or views of a fullselect) using the specified input data. Rows in the target that match the input data are updated as specified, and rows that DO NOT exist in the target are inserted. Updating or inserting a row into a view updates or inserts the row into the tables on which the view is based, if no INSTEAD OF trigger is defined on this view.
0
0
merge is wrong answer. Merge is not set operator.
0
0
Using the EXCEPT keyword
The EXCEPT keyword returns the result set of the first subselect minus any matching rows from the second subselect.
0
0