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. 2

  3. 3

  4. 4
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To prevent a Cartesian product when joining N tables, you need at least N-1 join conditions. For a four-table join, this means a minimum of 3 conditions are required in the WHERE clause to properly link all relations.

Keep practicing — related questions