ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

96 / 120

Question 96:

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables. 
image
Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment. SELECT EMPLOYEE_ID - FROM EMPLOYEES - WHERE JOB_ID = `SA_MAN` ------------------------------------- SELECT EMPLOYEE_ID - FROM JOB_HISTORY - WHERE JOB_ID = `SA_MAN`; Choose two correct SET operators which would cause the query to return the desired result. 

Answer options:

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