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.

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

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

When a foreign key in one table is referenced in another table, then in the secondary table, that column is referred to as a primary key.Group of answer choicesTrueFalse

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

Which of the following keys is generally used to represents the relationships between the tables?a.Primary keyb.Foreign keyc.None of the aboved.Secondary key