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

In contrast to a ____-join, an anti-join returns one copy of each row in the first table in which a match is found, but no matches are found in the ____-join

12. In contrast to a ____-join, an anti-join returns one copy of each row in the first table in which a match is found, but no matches are found in the ____-join.

1. Semi
2. Anti
3. Cross
4. None

Answer: A) Semi

Explanation:

In contrast to a semi-join, an anti-join returns one copy of each row in the first table in which a match is found, but no matches are found in the semi-join.