Which of the following is NOT true regarding foreign keys?
A)The AutoNumber data type is typically used for foreign key fields.
B)A foreign key is a field in a table that stores a value that is the primary key in another table.
C)It is called foreign because it identifies a record in another table.
D)Foreign keys do not need to be unique in the table.

Question

Quizplus · Accepted Answer

The AutoNumber data type is typically used for primary keys, not foreign keys. Foreign keys are usually set to match the data type of the primary key they reference, which is often an integer or another compatible type.

Which of the Following Is NOT True Regarding Foreign Keys