Sales data of a company is stored in two tables, SALES1 and SALES2, with some data being duplicated across
the tables. You want to display the results from the SALES1 table, which are not present in the SALES2 table.
SALES1 table
Name Null Type
—————— ————- —————-
SALES_ID NUMBER
STORE_ID NUMBER
ITEMS_ID NUMBER
QUANTITY NUMBER
SALES_DATE DATE
SALES2 table
Name Null Type
—————- ————- —————–SALES_ID NUMBER
STORE_ID NUMBER
ITEMS_ID NUMBER
QUANTITY NUMBER
SALES_DATE DATE
Which set operator generates the required output?
A.
INTERSECT
B.
UNION
C.
PLUS
D.
MINUS
E.
SUBTRACT
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries004.htm
D. SELECT store_id, items_id, quantity sales_date from SALES1
MINUS
select store_id, items_id, quantity sales_date from SALES2;