The ON DELETE and ON UPDATE clauses to apply the cascading referential integrity constraint.What is correct statement aboutON DELETE | ON UPDATE CASCADE:Specifies that if an attempt is made to delete or update a primary key record, an error will be raised and the delete or update operation will be rolled backed Specifies that if an attempt is made to update or delete a primary key record, the corresponding foreign key record is also updated or deleted, respectively. Specifies that if an attempt is made to delete or update a primary key record, the corresponding foreign key record is set to NULL. Specifies that if an attempt is made to delete or update a primary key record, the corresponding foreign key record is set to its default values

What does the SQL CASCADE constraint do?OptionsDeletes all related records when the referenced record is deletedDeletes only the referencing record when the referenced record is deletedUpdates all related records when the referenced record is updatedPrevents the deletion of the referenced record

When the referential integrity rule is enforced, which one is usually NOT a valid action in response to the deletion of a row that contains a primary key value referenced elsewhere?Choose one answer. a. Accept the deletion without any other action b. Set the foreign keys of related rows to null c. Do not allow the deletion d. Delete the related rows

When you select Cascade Update Related Fields, what does this do to the foreign keys involved in the relationship?Group of answer choicesForms a Many-to-Many relationship.When the primary key is deleted, the foreign keys will be deleted that reference the primary key.The Foreign Keys will be updated if the Primary Key is updated.When the foreign keys are updated, they will update the primary keys.

When creating a foreign key, how can you define an action to take if a parent table row is updated? 1 pointUse the CREATE TABLE commandUse the ON DELETE CASCADE clauseUse the rule clauseUse the ALTER TABLE command

2. Describe the differences between the SQL UPDATE and DELETE statements. When would you use one over the other, and what precautions should be taken?