Home »
MCQs »
Oracle MCQs »
Oracle Cross, Anti, and Semi Joins MCQs
If no match is found for a row in the first table, then an ___-join returns a copy of each row
7. If no match is found for a row in the first table, then an ___-join returns a copy of each row.
- Cross
- Semi
- Anti
- None
Answer: C) Anti
Explanation:
If no match is found for a row in the first table, then an anti-join returns a copy of each row.