Oracle Database SQL — Question 99

Which three statements are true about inner and outer joins? (Choose three.)

Answer options

• A. A full outer join returns matched and unmatched rows.
• B. Outer joins can be used when there are multiple join conditions on two tables.
• C. A full outer join must use Oracle syntax.
• D. Outer joins can only be used between two tables per query.
• E. A left or right outer join returns only unmatched rows.
• F. An inner join returns matched rows.

Correct answer: A, B, F

Explanation

Option A is correct as a full outer join indeed returns both matched and unmatched rows. Option B is also accurate because outer joins can handle multiple join conditions across two tables. Option F is valid because an inner join specifically returns only the rows that have matching values in both tables. The other options are incorrect or misleading regarding the usage of outer joins.