Oracle Database SQL — Question 209

Which two statements are true about a full outer join? (Choose two.)

Answer options

• A. It returns matched and unmatched rows from both tables being joined.
• B. The Oracle join operator (+) must be used on both sides of the join condition in the WHERE clause.
• C. It returns only unmatched rows from both tables being joined.
• D. It includes rows that are returned by an inner join.
• E. It includes rows that are returned by a Cartesian product.

Correct answer: A, D

Explanation

A full outer join retrieves both matched and unmatched records from the involved tables, making option A correct. Option D is also correct as it encompasses all rows that an inner join would return. The other options are inaccurate because option B refers to a specific syntax not used in full outer joins, option C incorrectly suggests that only unmatched rows are returned, and option E describes a Cartesian product, which is not relevant to full outer joins.