Multiple choice technology databases

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

  1. 8

  2. 3

  3. 5

  4. There is no such criteria
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To join N tables, you generally need a minimum of N-1 join conditions to avoid a Cartesian product. For four tables, 4 - 1 = 3 conditions are required to link them all together in a single chain or tree.

Keep practicing — related questions