Oracle
1Z0-074 · Question #73
Which three statements are true about inner and outer joins? (Choose three.)
The correct answer is B. An inner join returns matched rows C. A left or right outer join returns only unmatched rows D. A full outer join returns matched and unmatched rows. Explanation/Reference:
New Features for Manageability
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
(65 responses)- A15% (10)
- B74% (48)
- E3% (2)
- F8% (5)
Explanation
Explanation/Reference:
Topics
#SQL joins#inner join#outer join#full outer join
Community Discussion
No community discussion yet for this question.