Oracle 11G SQL 2nd Edition By Joan Casteel – Test bank

Chapter 11: Group Functions
TRUE/FALSE
1. Group functions return a group of results per row processed.
ANS: F PTS: 1 REF: 384
2. Group functions return one result per group of rows processed.
ANS: T PTS: 1 REF: 384
3. AVG, COUNT, and STDDEV are all considered group functions.
ANS: T PTS: 1 REF: 384
4. Group functions are also known as aggregate functions.
ANS: T PTS: 1 REF: 386
5. The only group function that includes NULL values by default is the MIN function.
ANS: F PTS: 1 REF: 384
6. The SUM function is used to calculate the total amount stored in a numeric field for a group of
records.
ANS: T PTS: 1 REF: 386
7. By default, the SUM function assumes the ALL keyword and the result will include multiple
occurrences of numeric values.
ANS: T PTS: 1 REF: 386
8. The optional UNIQUE keyword instructs Oracle 11g to include only unique numeric values in its
calculation.
ANS: F PTS: 1 REF: 386
9. By default, the AVG function will include NULL values when calculating the average of the
numeric values in a specified column.
ANS: F PTS: 1 REF: 389|390
10. The COUNT function can be used to count NULL, as well as, non-NULL values.
ANS: T PTS: 1 REF: 390
11. The COUNT(*) function is only used to count the number of records containing NULL values.
ANS: F PTS: 1 REF: 390