Based on the Code Shown, Which Query Lists the Descriptions

question 18

Multiple Choice

Based on the code shown, which query lists the descriptions of all items that are located in Storehouse3 and for which there are more than 20 units on hand???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )

• A) SELECT Description FROM Item WHERE Storehouse='3' AND OnHand>20 ;
• B) SELECT Description FROM Item WHERE Storehouse='3' OR OnHand>20 ;
• C) SELECT Description FROM Item WHERE Storehouse='3' ;
• D) SELECT Description FROM Customer WHERE Storehouse='3' AND OnHand>20 ;

---

Definitions:

Capital Structure

The particular combination of debt and equity used by a firm to finance its overall operations and growth.

Market Value

The current quoted price at which an asset or a company is bought or sold on the marketplace.

Book Value

The total worth of a corporation's assets after deducting its liabilities, as stated in the balance sheet.

Weighted-Average Cost

A calculation that takes into account the varying costs of items or resources, weighted by their relative importance or quantity.