Multiple choice

How many join conditions should be there to avoid a cartesian join for joining three tables?

  1. 1

  2. 2

  3. 3

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To avoid a cartesian product when joining n tables, you need n-1 join conditions. For 3 tables, that's 2 join conditions. Each condition links one new table to the existing result set. Without sufficient join conditions, every row from every table matches every other row - an explosive cartesian product.

Keep practicing — related questions