Multiple choice technology databases

An outer join is used to:

  1. Return records which have no direct match

  2. Return records which have direct match

  3. Return all the records

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

While an inner join only returns rows with matching values in both tables, an outer join also retrieves rows from one or both tables that do not have a corresponding match in the other, filling missing values with NULL. This makes it ideal for finding unmatched records.

Keep practicing — related questions