Multiple choice technology databases

What type of joins extends the result of a simple join

  1. left join

  2. right join

  3. outer join

  4. equil join

  5. simple join
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

An outer join (C) extends a simple join by including non-matching rows from one or both tables. A simple join is typically an inner join that only returns matching rows. Left joins (A) and right joins (B) are specific types of outer joins, making 'outer join' the broader, more general answer. An equijoin (D) is a basic inner join based on equality, not an extension.

Keep practicing — related questions