If you add a table with 10 records to a query and add an unrelated table with 4 records to the same query,how many records will display when you run the query?
A)40
B)10
C)4
D)0 (since the tables are not related)

Question

Quizplus · Accepted Answer

Adding an unrelated table will not affect the number of records displayed from the original table, so all 10 records from the first table will be displayed. However, since there are no relationships between the two tables, the additional 4 records from the second table will not be joined with any records from the first table, resulting in a total of 40 records being displayed.

If You Add a Table with 10 Records to a Query