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;

Question

Quizplus · Accepted Answer

To determine the total value of inventory held on hand, we need to calculate the product of the quantity on hand (P_QOH) and the price per unit (P_PRICE) for each item in the PRODUCT table. Option C provides the correct calculation with the appropriate columns and aliases. Option A calculates the QOH/Price ratio instead of the value of inventory. Option B uses the equality operator instead of the multiplication operator. Option D subtracts the price from the quantity instead of multiplying them.

Which Query Will Use the Given Columns and Column Aliases