Multiple choice technology programming languages

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

An outer join returns all records from one table and matching records from another, or all records from both tables. The key characteristic is that it includes records without direct matches (unlike inner joins). Option A best captures this essential behavior among the choices.

Keep practicing — related questions