← Quiz: SQL Joins: all 10 questions
Quiz: SQL Joins · Question 10 of 10
What usually happens if the ON condition is forgotten in a join of two large tables?
What usually happens if the ON condition is forgotten in a join of two large tables?
- A.Every row is paired with every row — an accidental cross join with a huge result
- B.The database picks the right columns automatically
- C.Only the first rows are joined
- D.The query returns zero rows
Answer & explanation
Correct answer: Every row is paired with every row — an accidental cross join with a huge result
Without a join condition you get the Cartesian product.
Can you get the rest right without peeking?
Take the timed Quiz: SQL Joins quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →