Which of the following foreign key constraint specifies that the deletion fails with an error ?
A. NO ACTION
B. CASCADE
C. SET NULL
D. All of the mentioned
Answer:A
Which of the following foreign key constraint specifies that the deletion fails with an error ?
A. NO ACTION B. CASCADE C. SET NULL D. All of the mentioned
Explanation:The ON UPDATE clause defines the actions that are taken if you try to update a candidate key value to which existing foreign keys point.