Which three statements are true about inner and outer joins? (Choose three.)

The correct answer is A. A full outer join returns matched and unmatched rows B. An inner join returns matched rows F. A left or right outer join returns only unmatched rows. See the full explanation below for the reasoning.

SQL and PL/SQL

Question

Options

AA full outer join returns matched and unmatched rows
BAn inner join returns matched rows
COuter joins can only be used between two tables per query
DA full outer join must use Oracle syntax
EOuter joins can be used when there are multiple join conditions on two tables
FA left or right outer join returns only unmatched rows

How the community answered

(22 responses)

A
82% (18)
C
5% (1)
D
5% (1)
E
9% (2)

Topics

#inner join#outer join#full outer join#join types

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice