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

A ____ subquery can be efficiently performed by using a Semijoin

9. A ____ subquery can be efficiently performed by using a Semijoin.

1. WHERE IS
2. WHERE TO
3. WHERE FOR
4. WHERE EXISTS

Answer: D) WHERE EXISTS

Explanation:

A WHERE EXISTS subquery can be efficiently performed by using a Semijoin.