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:

Prepaid Expense

An expense that has been paid in advance and is recorded as an asset until it is actually incurred.

Unearned Revenue

Unearned revenue refers to payment received for goods or services that have not yet been delivered or rendered. It is recorded as a liability on the balance sheet until the transaction is completed.

Accrued Expense

Expenses that have been incurred but not yet paid for, recognized in the accounting periods they are incurred rather than when cash changes hands.

Unearned Revenue

Income received by a company for goods or services that have not yet been delivered or performed; it is recorded as a liability on the balance sheet until the goods or services are provided.