🎴 Flashcard Mode
Oracle Practice Test - 26
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 join 3 tables without a Cartesian product, you need 2 join conditions. For N tables, you need N-1 join conditions. With 3 tables (A, B, C), you'd join A-B and B-C with 2 separate conditions.