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:

Variance

A statistical measure of the dispersion of a set of data points in relation to their mean.

Mean

The arithmetic average of a set of numbers, calculated by adding all the numbers together and dividing by the count of numbers.

Variance

A measure of the dispersion or spread of a set of data points around their mean value.

Degrees of Freedom

The number of independent values or quantities that can vary in the calculation of a statistic, often necessary for assessing the significance of the statistic.