Contents of BOOKS Table

question 50

Multiple Choice

Contents of BOOKS table
​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will display the title and retail price of each book stored in the BOOKS table in order of category and retail price?​

• A) ​SELECT title,retail FROM books ORDER BY category,retail;
• B) ​SELECT title,retail FROM books ORDERED BY category,retail;
• C) ​SELECT title,retail FROM books SORT BY category,retail;
• D) ​none of the above

---

Definitions:

T Distribution

A probability distribution that emerges in the context of estimating the mean for a normally distributed population, applicable when dealing with a small sample size and the population standard deviation is not known.

Degrees of Freedom

The number of independent pieces of information available to estimate another parameter or the number of values in the final calculation of a statistic that are free to vary.

Interval Estimation

A range within which a population parameter is estimated to lie, based on sample data and a certain level of confidence.

Standard Deviation

The statistic that measures the dispersion of a dataset relative to its mean and is calculated as the square root of the variance.