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;
Correct Answer:

Verified
Correct Answer:
Verified
Q15: You can select partial table contents by
Q21: A database language enables the user to
Q25: The command would be used to delete
Q26: A specialty field in mathematics,known as _
Q28: To delete a row from the PRODUCT
Q35: The SQL aggregate function that gives the
Q43: Which of the following is used to
Q52: The COUNT function is designed to tally
Q53: The special operator used to check whether
Q104: The command is used with the ALTER