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

When a ____-join is applied, one copy of every row in the first table with at least one matching row will be returned

10. When a ____-join is applied, one copy of every row in the first table with at least one matching row will be returned.

1. Self
2. Semi
3. Anti
4. Outer

Answer: B) Semi

Explanation:

When a semi-join is applied, one copy of every row in the first table with at least one matching row will be returned.