Oracle
1Z0-071 · Question #114
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…
The correct answer is A. UNION D. UNION ALL. See the full explanation below for the reasoning.
Question
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.
Exhibit
Options
- AUNION
- BMINUS
- CINTERSECT
- DUNION ALL
How the community answered
(46 responses)- A80% (37)
- B4% (2)
- C15% (7)
Community Discussion
No community discussion yet for this question.
