To retrieve a list of all values that appear in one table and not in another,which operator would be used?
A)MINUS
B)SUBTRACT
C)UNION
D)INTERSECT

Question

Quizplus · Accepted Answer

The MINUS operator is used to retrieve the set of records from the first query that are not present in the second query. It is similar to the SQL equivalent of a set difference operation. Therefore, in order to retrieve a list of all values that appear in one table and not in another, we would use the MINUS operator.

To Retrieve a List of All Values That Appear in One