Multiple choice technology databases

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 (cross join) when joining N tables, you generally need a minimum of N-1 join conditions. For three tables (N=3), you need 3-1 = 2 join conditions to link them correctly.

Keep practicing — related questions