Oracle
1Z0-071 · Question #319
1Z0-071 Question #319: Real Exam Question with Answer & Explanation
The correct answer is A. It includes rows that are returned by an inner join. D. It returns matched and unmatched rows from both tables being joined.. See the full explanation below for the reasoning.
Question
Which two statements are true about a full outer join? (Choose two.)
Options
- AIt includes rows that are returned by an inner join.
- BIt returns only unmatched rows from both tables being joined.
- CIt includes rows that are returned by a Cartesian product.
- DIt returns matched and unmatched rows from both tables being joined.
- EThe Oracle join operator (+) must be used on both sides of the join condition in the WHERE
Community Discussion
No community discussion yet for this question.