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:

Engagement Ring

A ring typically given during a proposal of marriage, symbolizing intent to marry.

Eternity

A concept referring to an infinite or unending time duration.

Symbolize

To represent something else, typically an idea, belief, or concept, through the use of symbols.

Devitalized

Refers to something that has lost its vitality, energy, or life force.