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:

World Supply

World supply refers to the total quantity of a good or service that is available for purchase on the global market.

OPEC Countries

Nations that are members of the Organization of the Petroleum Exporting Countries, known for their significant role in global oil production and prices.

Technological Advance

The progress in scientific research and development leading to new inventions or improvements in technology that can increase productivity and economic growth.

Demand

The willingness and ability of consumers to purchase goods and services at various prices during a certain period.