Chapter 5

Question 1

Which of the following is not an aggregate function?

a. ADD_MONTH()
b. MAX()
c. AVG()
d. COUNT()

Answer 1

a. ADD_MONTHS()

This is a date and time function that adds a number of months to a specified date.

Question 2

Which of the following statements best describes what the MIN() function is used for?

a. it is used to sort data in descending order.
b. it is used to tell the database which table to retrieve columns from.
c. it is used to substitute a name for a field or value.
d. it is used to locate and return the lowest value in a column.

Answer 2

d. it is used to locate and return the lowest value in a column.

The MIN() function is used to return the lowest value in a column.

Question 3

Which of the following clusters data into groups and then performs an aggregate function on the group?

a. LIKE
b. ORDER BY
c. GROUP BY
d. LTRIM()

Answer 3

c. GROUP BY

The GROUP BY clause is used to cluster data into groups and then perform an aggregate function on the group.

Question 4

Which of the following is used to specify a specific search criterion (filter) on a group of data?

a. IN
b. HAVING
c. NOT
D. RTRIM()

Answer 4

b. HAVING

The HAVING clause enables you to speciy specific search criteria (filter) on groups of data.

Question 5

Which of the following is used to specify a specific search criterion (filter) on a group of data?

a. IN
b. HAVING
c. NOT
D. RTRIM()

Answer 5

b. HAVING

The HAVING clause enables you to specify specific search criteria (filter) on groups of data.