Home » MCQs » Oracle MCQs » Oracle Inner, Outer, Equi, and Self Joins MCQs

____ Outer join returns all rows from the left (first) table that are specified by the ON condition, and all rows from the right table that are met by the join condition

4. ____ Outer join returns all rows from the left (first) table that are specified by the ON condition, and all rows from the right table that are met by the join condition.

1. Left
2. Right
3. Middle
4. None

Answer: A) Left

Explanation:

This join returns all rows from the left (first) table that are specified by the ON condition and all rows from the right table that are met by the join condition.