Question

Which of the following statements is true about referential integrity?

A. It checks that no component of a primary key can have a null value and no duplicate entries can exist.
B. It checks that the value of a primary key must beconsistent throughout the life of an instance.
C. It distinguishes between null values and zero entries.
D. It checks that no record in a child table can exist if its corresponding record is not available in the parent table.

Answer 1

The correct answer is:

D. It checks that no record in a child table can exist if its corresponding record is not available in the parent table.

Referential integrity in a database refers to the consistency and accuracy of relationships between tables, particularly when foreign keys and primary keys are used. Option D accurately describes the concept of referential integrity by stating that it ensures that child table records (dependent records) cannot exist unless their corresponding records (parent records) are available in the parent table. This helps maintain data integrity and consistency within the database.

Step-by-step explanation: