Oracle
1Z0-071 · Question #351
Which three statements are true about inner and outer joins? (Choose three.)
The correct answer is B. An inner join returns matched rows D. A full outer join returns matched and unmatched rows F. Outer joins can be used when there are multiple join conditions on two tables. See the full explanation below for the reasoning.
Question
Which three statements are true about inner and outer joins? (Choose three.)
Options
- AA full outer join must use Oracle syntax
- BAn inner join returns matched rows
- CA left or right outer join returns only unmatched rows
- DA full outer join returns matched and unmatched rows
- EOuter joins can only be used between two per query
- FOuter joins can be used when there are multiple join conditions on two tables
How the community answered
(34 responses)- A3% (1)
- B76% (26)
- C15% (5)
- E6% (2)
Community Discussion
No community discussion yet for this question.