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.

1. Cross
2. Semi
3. Anti
4. 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.