When you define a foreign key constraint, you can determine all but one of the following. Which one is it?
A. that the deletion of a row in a primary key table should cause the foreign keys in related rows in the foreign key table to be set to nulls
B. that no action should be taken and an error should be returned when referential integrity is going to be violated
C. that the insertion of a row in a foreign key table that has a foreign key that isn't matched in the primary key table should be cascaded up to the primary key table
D. that the deletion of a row in a primary key table should be cascaded down to related rows in the foreign key table
Answer: C. that the insertion of a row in a foreign key table that has a foreign key that isn't matched in the primary key table should be cascaded up to the primary key table
You might also like to view...
What is the disadvantage of MIDI compared to composing music with loop music?
What will be an ideal response?
GPS stands for ________
Fill in the blank(s) with correct word
Perform a cash flow analysis to track the money coming in and going out
Indicate whether the statement is true or false
If an object absorbed 100% of the light that strikes it, how would it appear?
A. it would appear as a rainbow B. it would be white C. it would be invisible D. it would be black