Choose the correct SET operator to fill in the blank space and complete the following query…

Prev Question
Next Question

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.

Exam 1Z0-047 - Choose the correct SET operator to fill in the blank space and complete the following query…

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
FROM job_history
WHERE job_id=’SA_MAN’;

A.
UNION

B.
MINUS

C.
INTERSECT

D.
UNION ALL

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *