If You Have a Foreign Key in a CUSTOMER Table

question 29

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

---

Definitions:

Six-Figure Accuracy

A level of precision in numerical calculation or measurement that extends to at least 100,000 but less than 1,000,000.

Superscript

A character, letter, or symbol that is set slightly above the normal line of type, frequently used in mathematical expressions and citations.

Six-Figure Accuracy

A level of precision in calculations or measurements that results in a six-digit number.

Powers

The product of multiplying a number by itself a specified number of times.