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 join 3 tables without a Cartesian product, you need 2 join conditions. For N tables, you need N-1 join conditions. With 3 tables (A, B, C), you'd join A-B and B-C with 2 separate conditions.

Keep practicing — related questions