nerdexam
Oracle

1Z0-047 · Question #25

View the Exhibit and examine the table structure of DEPARTMENTS and LOCATIONS tables. You want to display all the cities that have no departments and the departments that have not been allocated…

The correct answer is B. FULL OUTERJOIN. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the table structure of DEPARTMENTS and LOCATIONS tables. You want to display all the cities that have no departments and the departments that have not been allocated cities. Which type of join between DEPARTMENTS and LOCATIONS tables would produce this information as part of its output?

Exhibit

1Z0-047 question #25 exhibit

Options

  • ANATURAL JOIN
  • BFULL OUTERJOIN
  • CLEFT OUTERJOIN
  • DRIGHT OUTER JOIN

How the community answered

(44 responses)
  • A
    18% (8)
  • B
    70% (31)
  • C
    5% (2)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice