If you have a foreign key in a CUSTOMER table that references the primary key in a SALESREP table,the ON DELETE CASCADE syntax means that ________.
A)when a CUSTOMER is deleted,that CUSTOMER's SALESREP is also deleted
B)when a CUSTOMER is deleted,all SALESREPS are also deleted
C)when a SALESREP is deleted,all CUSTOMERs of that SALESREP are also deleted
D)when the SALESREP table is dropped,all CUSTOMERs must be deleted

Question

Quizplus · Accepted Answer

The ON DELETE CASCADE syntax means that when a SALESREP is deleted, all CUSTOMERs of that SALESREP will also be deleted. So, option C is the correct choice. Option A is incorrect because when a CUSTOMER is deleted, it does not necessarily mean that the SALESREP is deleted as well. Option B is also incorrect as it suggests that all SALESREPs will be deleted when a CUSTOMER is deleted. Option D is incorrect because the ON DELETE CASCADE syntax does not have any impact on what happens when a table is dropped.

If You Have a Foreign Key in a CUSTOMER Table