What is the most likely cause when a multiple-table query returns more records than you expect?
A)Missing join condition
B)Too much data
C)Used an outer join when you should have used an inner join
D)DBMS made a mistake

Question

Quizplus · Accepted Answer

When a multiple-table query returns more records than expected, it's likely that there is a missing join condition. This results in a Cartesian product, which can produce a much larger result set than intended.

Answer: C
 Using an outer join when an inner join would have been more appropriate can also result in a larger result set than expected. However, this would be less likely than a missing join condition.

Answer: D
 While it's possible for a DBMS to make a mistake, this would be less likely than the other two options mentioned above. It's best to first check your query and data to ensure there are no errors before assuming the DBMS is at fault.

Therefore, the best answer would be A: Missing join condition.

What Is the Most Likely Cause When a Multiple-Table Query