Multiple choice technology databases

A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in the where clause then result will have

  1. 100 rows

  2. 50 rows

  3. 150 rows

  4. 5000 rows
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When joining two tables without a WHERE clause specifying the join condition, you get a Cartesian product (cross join). Every row in T1 pairs with every row in T2, so 100 rows x 50 rows = 5000 rows. This is a common SQL mistake that produces much more data than intended.

Keep practicing — related questions