nerdexam
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

1Z0-071 question #114 exhibit

Options

  • AUNION
  • BMINUS
  • CINTERSECT
  • DUNION ALL

How the community answered

(46 responses)
  • A
    80% (37)
  • B
    4% (2)
  • C
    15% (7)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice