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.
- SELF
- INNER
- OUTER
- 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.