Question 96:
View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.
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