_ If a relationship has a cascade updates constraint, then if ________ – 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

Which is true about surrogate keys?
An ideal primary key is short, numeric and seldom changing.%!
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.%!
An intersection table is required to represent M:N relationships.%!
In a 1:1 relationship, the primary key placement is arbitrary.%!
For every relationship, there are six possible referential integrity actions.%!
Surrogate keys have much meaning for users.%!
For every relationship, there are six possible sets of minimum cardinalities.%!
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.%!
When the parent entity is required, a new parent row can always be inserted.%!