Which of the Following Queries Will Use the Given Columns

question 48

Multiple Choice

Which of the following queries 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:

Plywood

A type of engineered wood product made by gluing together several thin layers or plies of wood veneer.

Breach Of Warranty

occurs when a promised statement of fact about a product or service is not true or is violated.

Limited Period

A specific, fixed amount of time during which something is operational, valid, or applicable.

Letter Of Credit

A written instrument, usually issued by a bank on behalf of a customer or other party, in which the issuer promises to honor drafts or other demands for payment by third parties in accordance with the terms of the instrument.