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. Incorrect answer: A meet a join condition B meet a join condition D meet non join condition only F does not take into consideration of primary key and foreign key relationship

Displaying Data from Multiple Tables and Subqueries

Question

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

(47 responses)

A
2% (1)
B
11% (5)
C
79% (37)
D
6% (3)
F
2% (1)

Explanation

You use an outer join to also see rows that do not meet the join condition. Incorrect answer: A meet a join condition B meet a join condition D meet non join condition only F does not take into consideration of primary key and foreign key relationship

Topics

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

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice