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

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

Since you choose to enforced the referential integrity while creating relationship between Employees table and Social Security table, which of the following would therefore be true?Group of answer choicesIt allows user from deleting a record from Social Security table when there are related records in Employees tableIt prohibits the user from entering a foreign key value in a Social Security table unless the primary key value already exists in the Employees tableIt allows you to enforce marriage between Employees table and Social Security tableIt prohibits the user from entering primary key value in Social Security table unless the foreign key value already exists in the Employees table

A relationship with referential integrity means that the foreign key must have an existing reference in the parent table.Question 4Select one:TrueFalse

Referential Integrity Constraint: Foreign Key

Which key is specifically used to enforce referential integrity between two tables?Group of answer choicesComposite KeyPrimary KeySuper KeyForeign Key