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

  2. 4

  3. 3

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

To join N tables without creating a Cartesian product, a minimum of N-1 join conditions are required. For a four-table join, this means at least three specific conditions must be present in the WHERE (or ON) clause to properly relate all tables.

Keep practicing — related questions