Introduction to Database1 Lab: Understanding Primary Keys

It prevents adding records in a table that contain a foreign key, unless there is a corresponding primary key in the reference table. (correct)

It maintains consistency between primary keys across different tables.

It ensures that all tables have both primary and foreign keys.

It allows adding any record in a table that contains a foreign key, regardless of the primary key in the reference table.

Do not delete data required by another table.

Allow duplicate primary keys in the parent table. (correct)

Do not add incompatible data to a child table.

Value of foreign key must exist in the primary key it refers to.

The deletion is allowed, and all related foreign keys are also deleted.

The deletion is not allowed, as it would violate referential integrity. (correct)

The deletion is allowed, but all related foreign keys are set to NULL.

The deletion is allowed, but a warning is displayed about the related foreign keys.

<p>A table can have multiple foreign keys referring to different primary keys.</p> Signup and view all the answers

<p>It ensures that all foreign keys in a table have matching primary keys in the parent table.</p> Signup and view all the answers