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.
- Self
- Semi
- Anti
- 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.