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. UNION
B. MINUS
C. INTERSECT
D. UNION ALL
|
Download Printable PDF. VALID exam to help you PASS. |
 |