🎴 Flashcard Mode
Oracle Database and SQL Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
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?
AnswerClick to flip back
A
3
💡 Explanation:
To join n tables without Cartesian products, you need at least (n-1) join conditions in the WHERE clause (or using ANSI JOIN syntax). For 4 tables, this means 3 conditions linking them in a chain (e.g., T1 join T2, T2 join T3, T3 join T4). Without adequate join conditions, the database creates a Cartesian product, resulting in every possible row combination (multiplying all row counts).