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:

Wildcat Fund

A high-risk investment fund that invests in speculative ventures, such as unproven oil reserves or start-up companies.

Style Analysis

An investment strategy analysis tool used to understand the performance of a portfolio by identifying the factors contributing to its returns.

Fund Returns

The profit or loss on an investment over a specific period, often expressed as a percentage of the investment's initial value.

Asset Allocation

Asset allocation is an investment strategy that aims to balance risk and reward by apportioning a portfolio's assets according to an individual's goals, risk tolerance, and investment horizon.