Oracle
1Z0-082 · Question #81
Examine the description of the SALES1 table: SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables. You want to display the rows from the SALES1 table…
The correct answer is E. MINUS. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Examine the description of the SALES1 table:
SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables. You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?
Exhibit
Options
- AINTERSECT
- BUNION ALL
- CUNION
- DSUBTRACT
- EMINUS
How the community answered
(29 responses)- A3% (1)
- B3% (1)
- C7% (2)
- D17% (5)
- E69% (20)
Topics
#set operators#MINUS#UNION#query results
Community Discussion
No community discussion yet for this question.