The correct answer is SQL supports the modifier ON UPDATE and ON DELETE for foreign key definitions.
Foreign keys cannot handle deletes and updates. Explanation: A foreign key is the one which declares that an index in one table is related to that in another and place constraints. ON DELETE CASCADE means if the parent record is deleted, then any referencing child records are also deleted. ON UPDATE defaults to RESTRICT, which means the UPDATE on the parent record will fail. ON DELETE action defaults to RESTRICT, which means the DELETE on the parent record will fail.
To learn more about ON UPDATE and ON DELETE click the link below:
brainly.com/question/15514353
#SPJ4
