Definitely B. NO ACTION means the database doesn't do anything special when deleting the parent key. It's up to the application to handle the referential integrity.
Haha, I almost picked D just for the fun of it. Automatically setting all child keys to a specified value? That's a bit extreme for a 'NO ACTION' constraint!
I think the correct answer is B. The question clearly states 'NO ACTION', which means no test is made for referential integrity when deleting the parent key.
Brandee
15 days agoMel
2 days agoPrecious
16 days agoRyan
20 days agoVerlene
22 days agoYolande
24 days agoAnnice
3 days agoTarra
5 days agoNickole
6 days agoGladys
25 days agoRyan
29 days ago