Home » MCQs » Oracle MCQs » Oracle Cross, Anti, and Semi Joins MCQs

All rows from the first table will join with all of the rows from the second table in a ____ JOIN

1. All rows from the first table will join with all of the rows from the second table in a ____ JOIN.

1. SELF
2. INNER
3. OUTER
4. CROSS

Answer: D) CROSS

Explanation:

All rows from the first table will join with all of the rows from the second table in a CROSS JOIN.