🎴 Flashcard Mode
SQL Group Functions and Database Operations
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 (or cross join) occurs when: (1) no join condition is specified, (2) the join condition is invalid, or (3) when all rows from one table are joined to all rows from another. All three scenarios lead to every row in the first table being combined with every row in the second table.