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:

Public Pressure

The influence or persuasion exerted by society or a group of people on an individual or organization to perform a certain way.

Core Management Group

The central team of decision-makers in an organization responsible for setting strategy, making critical operational decisions, and leading the organization towards its goals.

Authorization Card

A document that indicates an employee's willingness to be represented by a labor union in negotiations with their employer.

Representation Election

A voting process by which employees decide whether or not they wish to be represented by a labor union.