Multiple choice technology databases

An outer join requires each record in the two joined tables to have a matching record.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Outer joins (LEFT, RIGHT, FULL) do NOT require matching records - they return all records from one or both tables, with NULLs filling in for non-matching rows. Only inner joins require matches on both sides.