Which of the following is NOT true about referential integrity?
A) The matching fields on both sides of the relationship have the same data types.
B) You cannot enter a value in the foreign key field on the many side table that is not a primary key on the one side table.
C) The primary key field values on the one side of the relationship must be unique.
D) All foreign key fields and primary key fields must have values entered and cannot remain null.

Question

Quizplus · Accepted Answer

The statement "All foreign key fields and primary key fields must have values entered and cannot remain null" is not always true about referential integrity. Depending on the database design and requirements, it may be acceptable to have null values in certain fields. However, referential integrity does require that any non-null foreign key field on the many side table must correspond to a valid primary key value on the one side table.

Which of the Following Is NOT True About Referential Integrity