Question

You cannot enforce referential integrity if which of the following is not true?

A) the linking field from the main table is a primary key.
B) the linked fields have the same data type
C) both tables belong to the same Microsoft Access database
D) the name of the common fields are the same

Answer 1

Referential integrity cannot be enforced if the linking field from the main table is not a primary key.

Step-by-step explanation:

If the linking field from the main table is not a primary key, you cannot enforce referential integrity. Referential integrity is a database constraint that ensures that relationships between tables are valid. When a field is a primary key, it uniquely identifies each record in a table, and when it's used as a linking field, it guarantees that the linked fields have a corresponding value in the main table. Therefore, option A) is the correct answer.