🎴 Flashcard Mode
Oracle Practice Test - 1
Card1 / 21
Mastered0
Review0
QuestionClick to flip
How many join conditions should be there to avoid a cartesian join for joining three tables?
AnswerClick to flip back
A
2
💡 Explanation:
To avoid a cartesian product when joining n tables, you need n-1 join conditions. For 3 tables, that's 2 join conditions. Each condition links one new table to the existing result set. Without sufficient join conditions, every row from every table matches every other row - an explosive cartesian product.