View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.
The query should display the employee IDs of all the employees who have held the job
SA_MAN at any time during their tenure. Choose the correct SET operator to fill in the blank
space and complete the following query. SELECT employee_id FROM employees WHERE
job_id = ‘SA_MAN’ ________________ SELECT employee_id FROMjob_history WHERE
job_id=’SA_MAN’
A.
INTERSECT
B.
UNION ALL
C.
UNION
D.
MINUS