🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.Every row is paired with every row — an accidental cross join with a huge result
  2. B.The database picks the right columns automatically
  3. C.Only the first rows are joined
  4. 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 →