nerdexam
Oracle

1Z0-071 · Question #381

Examine this statement which returns the name of each employee and their manager: You want to extend the query to include employees with no manager. What must you add before JOIN to do this?

The correct answer is A. CROSS. See the full explanation below for the reasoning.

Question

Examine this statement which returns the name of each employee and their manager:

You want to extend the query to include employees with no manager. What must you add before JOIN to do this?

Exhibit

1Z0-071 question #381 exhibit

Options

  • ACROSS
  • BRIGHT OUTER
  • CFULL OUTER
  • DLEFT OUTER

How the community answered

(38 responses)
  • A
    79% (30)
  • B
    5% (2)
  • C
    13% (5)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice