Which Query Will Use the Given Columns and Column Aliases

question 78

Multiple Choice

Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?

• A) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE
• FROM PRODUCT;
• B) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUE
• FROM PRODUCT;
• C) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUE
• FROM PRODUCT;
• D) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUE
• FROM PRODUCT;

---

Definitions:

Par Value

The face value of a bond or the stock value stated in the corporate charter, not necessarily related to its market value.

Fair Value

The estimated price at which an asset or liability could be traded in a fair transaction between willing parties.

Stock Issuance Costs

Expenses incurred by a company to register and issue shares of stock, such as legal, accounting, and printing costs.

Voting Shares

Shares of a corporation's stock that grant the shareholder the right to vote on corporate matters, such as the election of the board of directors.