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 these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To successfully join N tables without resulting in a Cartesian product, you need at least N-1 join conditions. For joining three tables, you need 2 join conditions to properly link them together.

Keep practicing — related questions