Oracle
1Z0-071 · Question #216
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 correct answer is D. MINUS. See the full explanation below for the reasoning.
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. Which set operator generates the required output?
Exhibit
Options
- AINTERSECT
- BUNION
- CPLUS
- DMINUS
- ESUBTRACT
How the community answered
(57 responses)- A14% (8)
- B2% (1)
- C7% (4)
- D74% (42)
- E4% (2)
Community Discussion
No community discussion yet for this question.