Prev Question
Next Question

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

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *