nerdexam
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

1Z0-047 question #51 exhibit

Options

  • AUNION
  • BMINUS
  • CINTERSECT
  • DUNIONALL

How the community answered

(51 responses)
  • A
    84% (43)
  • B
    10% (5)
  • C
    6% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice