Question 610
An order row joins to five order_items rows, and the result shows that order five times. What join relationship explains this?
Explanation
Correct Answer
Correct for one parent with multiple matches: One-to-many join can produce multiple rows per matching parent record.
Incorrect Answers
Not the right operation for one parent with multiple matches: Many-to-many join can multiply rows unexpectedly when both sides have duplicate join keys.
Not the right operation for one parent with multiple matches: Semi-join via EXISTS filters based on a match while avoiding row multiplication from the right side.
Not the right operation for one parent with multiple matches: Anti-join via NOT EXISTS finds records without a qualifying counterpart.