Which Query Will Use the Given Columns and Column Aliases

question 30

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?

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

---

Definitions:

Cost of Capital

The minimum profit percentage a corporation is required to generate from its investment initiatives to keep its market price stable and draw in financing.

Cash Flows

The total amount of money being transferred in and out of a business, especially affecting liquidity.

IRR

The Internal Rate of Return; a financial metric used to estimate the profitability of potential investments.

Equivalent Annual Annuity

A financial term referring to the annual cash flow from an investment over its lifespan, adjusted to reflect equal annual payments.