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:

Aldosterone

A hormone produced by the adrenal glands that helps regulate blood pressure by controlling sodium and water levels in the body.

ADH

Antidiuretic Hormone, a peptide hormone secreted by the pituitary gland that regulates the body's retention of water by increasing water reabsorption in the kidneys.

Blood Plasma

The liquid component of blood where cells are suspended, comprising water, salts, proteins, and various other substances.

Medullary Osmotic Gradient

A concentration gradient of solutes in the kidney's medulla that helps in the reabsorption of water from urine, contributing to the body's water balance.