The Query Used to List the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE

question 102

Multiple Choice

The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is .

• A) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE;
• B) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
• C) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
• D) SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;

---

Definitions:

Enzyme

Biological molecules that significantly speed up the rate of virtually all the chemical reactions within cells.

Molecule

The smallest unit of a chemical compound that can exist; composed of two or more atoms held together by covalent bonds.

Activation Energy

The minimum energy required to start a chemical reaction.

Enzyme

Biological molecules that act as catalysts to speed up chemical reactions in living organisms.