🎴 Flashcard Mode
SQL Joins and Functions
Card1 / 20
Mastered0
Review0
QuestionClick to flip
When is a Cartesian product formed?
AnswerClick to flip back
A
All of the above.
💡 Explanation:
A Cartesian product occurs when every row from one table is combined with every row from another table. This happens when a join condition is omitted (resulting in a cross join), when a join condition is invalid causing SQL to default to Cartesian behavior, or when explicitly defined. Option D correctly captures all these scenarios.