Multiple choice

Which type of join should be written to perform an outer join of tables A and B that returns all rows from B?

  1. Any outer join

  2. A left outer join

  3. A cross join

  4. A right outer join

  5. An inner join
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In a RIGHT OUTER JOIN, all rows from the right table (B) are returned, plus matching rows from the left table (A). Non-matching rows from A show NULL. A LEFT OUTER JOIN would return all from A, not B. An INNER JOIN only returns matching rows from both. A CROSS JOIN returns the Cartesian product (all combinations).

Keep practicing — related questions