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.
- WHERE IS
- WHERE TO
- WHERE FOR
- WHERE EXISTS
Answer: D) WHERE EXISTS
Explanation:
A WHERE EXISTS subquery can be efficiently performed by using a Semijoin.