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

____ is/are used for anti-joins

8. ____ is/are used for anti-joins.

1. NOT EXISTS
2. NOT IN
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

NOT EXISTS and NOT IN are used for anti-joins.