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

question 65

Multiple Choice

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

---

Definitions:

Brokerage Fees

Charges levied by a broker for executing transactions or providing specialized services.

Common Stock

A type of security that signifies ownership in a corporation, entitling the holder to a claim on part of the company's profits and assets.

Accrued Interest

Accrued Interest is the interest that has been incurred but not yet paid or received as of a specific date.

Equity Method

An accounting technique used to record investments in other companies, where the investment is initially recorded at cost and subsequently adjusted for the investor's share of the investee's profits or losses.