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 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.

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 JOIN clause do?OptionsSorts rows in a tableDeletes rows from a tableCombines rows from two or more tablesInserts rows into a table

Enforcing Referential integrity while creating relationship between two tables ensures that ___________________.Group of answer choicesData can be  recognized by the AccessData can be deleted in a related table even if has records in related tablesit enforces the gravity between two tablesData cannot be entered to related tables if original record doesn't exist in original table.

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