nerdexam
Oracle

1Z0-061 · Question #263

In which two cases would you use an outer join? (Choose two.)

The correct answer is C. The columns being joined have NULL values. E. The tables being joined have both matched and unmatched data. You use an outer join to also see rows that do not meet the join condition.

Displaying Data from Multiple Tables using Joins

Question

In which two cases would you use an outer join? (Choose two.)

Options

  • AThe tables being joined have NOT NULL columns.
  • BThe tables being joined have only matched data.
  • CThe columns being joined have NULL values.
  • DThe tables being joined have only unmatched data.
  • EThe tables being joined have both matched and unmatched data.
  • FOnly when the tables have a primary key/foreign key relationship.

How the community answered

(45 responses)
  • A
    13% (6)
  • B
    7% (3)
  • C
    76% (34)
  • D
    2% (1)
  • F
    2% (1)

Explanation

You use an outer join to also see rows that do not meet the join condition.

Topics

#outer join#NULL values#unmatched rows#join types

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-061 Practice