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 those
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 three tables, this means 2 join conditions are required. With fewer conditions, the database creates a Cartesian product between the unjoined tables.

Keep practicing — related questions