During the database redesign process,you discover that when an ORDER is deleted,its corresponding entries in the LINE_ITEM table are not deleted (but you would like them to be).In order to fix,this,you use what SQL syntax?
A)ON UPDATE CASCADE
B)ON DELETE CASCADE
C)CASCADE CONSTRAINTS
D)DEFAULT

Question

Quizplus · Accepted Answer

The ON DELETE CASCADE option can be used to automatically delete the corresponding entries in the LINE_ITEM table when an ORDER is deleted. This will ensure data consistency and prevent orphaned records in the database. Option A (ON UPDATE CASCADE) is used when updating a primary key that is referenced by foreign keys, whereas option C (CASCADE CONSTRAINTS) is used to cascade changes to all referenced tables. Option D (DEFAULT) is not relevant to this situation.

During the Database Redesign Process,you Discover That When an ORDER