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:

Strategic Planning

The process of defining a company’s direction and making decisions on allocating its resources to pursue this strategy.

Objectives

Specific, measurable goals set by an individual or organization that aim to achieve a desired outcome or performance level.

Mission Statement

A structured outline that describes the goals and ethics of a business, group, or individual.

Core Goals

Fundamental objectives that an organization or individual strives to achieve, which are central to its mission or purpose.