Home »
MCQs »
Oracle MCQs »
Oracle Cross, Anti, and Semi Joins MCQs
When two tables are ____ joined, no rows are returned from the first table if the second table has no matches
5. When two tables are ____ joined, no rows are returned from the first table if the second table has no matches.
- Equi
- Anti
- Cross
- None
Answer: B) Anti
Explanation:
When two tables are anti-joined, no rows are returned from the first table if the second table has no matches.