If a relationship has a cascade updates constraint, then if ________ i – McqOptions

MCQOPTIONS

1.	If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
A.	the primary key
B.	any alternate key
C.	a surrogate key
D.	a foreign key
Answer» B. any alternate key

Discussion

No Comment Found

Related MCQs

When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
Intersection tables are ID-dependent on both their parent tables.
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
Surrogate keys have much meaning for users.
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
An intersection table is required to represent M:N relationships.
When the parent entity is required, a new parent row can always be inserted.
For every relationship, there are six possible referential integrity actions.
All primary keys are required.
When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.