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

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

Question 13When must you use a Type I nested query in an UPDATE or DELETE statement?1 pointA non target table has row conditions.A non target table has combined primary key.A non target table has an optional foreign key.A non target table provides columns for the UPDATE statement.

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

ect the correct answerWhich SQL statement is used to make changes to the structure of an existing table without deleting it?OptionsDELETE TABLEMODIFY TABLEALTER TABLECHANGE TABLE

Which SQL statement is used to make changes to the structure of an existing table without deleting it?OptionsDELETE TABLEALTER TABLEMODIFY TABLECHANGE TABLE