When two tables containing 100 records each are used in a query and the query returns 10,000 records,you know this is a result of the multiplier effect.

Question

Quizplus · Accepted Answer

The multiplier effect occurs when joining two tables that have a many-to-many relationship, resulting in an increased number of records in the output. In this case, joining two tables with 100 records each can potentially result in up to 10,000 records in the output.

When Two Tables Containing 100 Records Each Are Used in a Query