If You Have a Foreign Key in a CUSTOMER Table

Multiple Choice

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