Oracle
1Z0-047 · Question #51
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…
The correct answer is A. UNION D. UNIONALL. See the full explanation below for the reasoning.
Question
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 FROM job_history WHERE job_id='SA_MAN'
Exhibit
Options
- AUNION
- BMINUS
- CINTERSECT
- DUNIONALL
How the community answered
(51 responses)- A84% (43)
- B10% (5)
- C6% (3)
Community Discussion
No community discussion yet for this question.
