Q: 17
Which two statements are true about a full outer join?
Options
Discussion
A and D
C , because a full outer join seems like it would include everything from both tables, so maybe that's like a Cartesian product? Not totally sure but feels close to what it's asking.
Option A and D here. Full outer join brings all matching (inner join) rows and also includes unmatched rows from both tables. The (+) operator can't do this, only FULL OUTER JOIN syntax does. Pretty confident but open to corrections.
For full outer joins, A and D line up with what the official Oracle SQL guide describes. You get all matched rows (like an inner join) plus unmatched from both tables. Pretty sure that's what similar exam questions expect. Anyone disagree?
Be respectful. No spam.