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

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

To avoid cartesian products when joining n tables, you need at least n-1 join conditions in the WHERE clause. This ensures each new table is linked to the previous ones in a chain. For 4 tables, you need 4-1 = 3 conditions.

Keep practicing — related questions