You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have? A. 5 B. 8 C. 24 D. Not enough information to tell

The correct answer is: D. Not enough information to tell

A right outer join will return all records from the left table, even if there is no matching record in the right table. It will also return all records from the right table where there is a matching record in the left table.

In this case, we know that the first table has 3 records and the second table has 8 records. However, we do not know how many of the records in the second table have a matching record in the first table. Therefore, we cannot determine how many records will be in the resulting recordset.

For example, if all 8 records in the second table have a matching record in the first table, then the resulting recordset will have 11 records (3 from the first table and 8 from the second table). However, if only 2 of the records in the second table have a matching record in the first table, then the resulting recordset will have 5 records (3 from the first table and 2 from the second table).

Without knowing how many of the records in the second table have a matching record in the first table, it is impossible to determine how many records will be in the resulting recordset.