W07 quiz CIT 225.docx - W07 quiz CIT 225 1. Single column...

W07 quiz CIT 225
1. Single column grouping is the simplest and most often used type of grouping.
a. True
b. False
2. The COUNT() function creates an explicit group when it is the only thing returned in the SELECT-
list.
3. The MIN() function returns the minimum value within a set.
4. Aggregation functions take only columns as arguments.
5. The following query uses the COUNT function to return the first letter of the last_name column
values from the customer table where the last_name column values that start with the letter ‘K’
or ‘M’ in ascending last_name order.
a. True
b. False
6. The following query uses the COUNT function to return the first letter of the last_name column
values from the customer table where the last_name column values from the customer table
where the last_name column values that start with the letter ‘K’ or ‘M’ in ascending last_name
order.
7. Which of the following creates an explicit group in a query? Multiple answers are possible.) 8. The following COUNT function calls always return the same value.