Based on the Code Shown, Which Query Deletes Any Row

question 64

Multiple Choice

Based on the code shown, which query deletes any row in the OrderLine table in which the item number is MT03???OrderLine (OrderNum, ItemNum, NumOrdered, QuotedPrice) ?Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

• A) DELETE FROM OrderLine WHERE ItemNum='MT03' ;
• B) DELETE FROM OrderLine WHERE ItemNum=MT03 ;
• C) REMOVE FROM OrderLine WHERE ItemNum='MT03' ;
• D) REMOVE FROM OrderLine WHERE ItemNum=MT03 ;

---

Definitions:

Fair Values

The approximate value for which a security or debt could be traded between informed, consenting parties in a fair deal.

Credit Balance

The amount of money in a financial account that indicates that a customer has funds or credits available to them.

Consolidated Cash

The total cash and cash equivalents held by a parent company and its subsidiaries, presented as a single figure on consolidated financial statements.

Common Stock

A type of equity ownership in a corporation, representing a claim on a portion of the company’s profits and the right to vote on matters affecting the company.