ExamQuestions.com

Register
Login
Oracle Database Administration I Exam Questions

Oracle

Oracle Database Administration I

27 / 52

Question 27:

Examine the description of the SALES1 table: 
image
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? 

Answer options:

A. INTERSECT
B. UNION ALL
C. UNION
D. SUBTRACT
E. MINUS