Question 1

​Which of the following can be used with character data?

Accepted Answer

A)  ​MIN 
B)  ​MAX 
C)  ​COUNT 
D)  ​all of the above 
A)  ​MIN 
B)  ​MAX 
C)  ​COUNT 
D)  ​all of the above

Question 2

If the DISTINCT keyword is not included in the STDDEV function,the ____ keyword will be assumed.​

Accepted Answer

A)  ​UNIQUE 
B)  ​ALL 
C)  ​NONULLS 
D)  ​none of the above 
A)  ​UNIQUE 
B)  ​ALL 
C)  ​NONULLS 
D)  ​none of the above

Question 3

Group functions can only be nested to a depth of two.​

Accepted Answer

A) True 
 B)False

Question 4

Which of the following cannot be used with date columns?​

Accepted Answer

A)  ​MIN 
B)  ​MAX 
C)  ​AVG 
D)  ​all of the above 
A)  ​MIN 
B)  ​MAX 
C)  ​AVG 
D)  ​all of the above

Question 5

​When a SELECT statement contains WHERE,GROUP BY,and HAVING clauses,the ____________________ clause is always evaluated first.

Accepted Answer

The answer of ​When a SELECT statement contains WHERE,GROUP BY,and...

Question 6

AVG,COUNT,and STDDEV are all considered group functions.​

Accepted Answer

A) True 
 B)False

Question 7

The HAVING clause serves as the WHERE clause for aggregated data._________________________​

Accepted Answer

A) True 
 B)False

Question 8

Column aliases can be used in the GROUP BY clause.​

Accepted Answer

A) True 
 B)False

Question 9

​The ____________________ function is used to determine how widely the numeric data contained within a specified column is spread out.

Accepted Answer

The answer of ​The ____________________ function is used to determine...

Question 10

The ____ function can be used to determine the largest value stored in a specified column.​

Accepted Answer

A)  ​MAXIMUM 
B)  ​MAX 
C)  ​LARGE 
D)  ​LARGEST 
A)  ​MAXIMUM 
B)  ​MAX 
C)  ​LARGE 
D)  ​LARGEST

Question 11

Contents of the BOOKS table​
  
-Based upon the contents of the BOOKS table,which of the following will display the retail price of the most expensive book provided by publisher 3?​

Accepted Answer

A)  ​SELECT MAX(retail)
FROM books
GROUP BY pubid; 
B)  SELECT MAXIMUM(retail)
FROM books
WHERE pubid = 3;​ 
C)  SELECT MAX(retail)
FROM books
WHERE pubid = 3; 
D)  ​SELECT MAXIMUM(retail)
FROM books
HAVING pubid = 3; 
A)  ​SELECT MAX(retail)
FROM books
GROUP BY pubid; 
B)  SELECT MAXIMUM(retail)
FROM books
WHERE pubid = 3;​ 
C)  SELECT MAX(retail)
FROM books
WHERE pubid = 3; 
D)  ​SELECT MAXIMUM(retail)
FROM books
HAVING pubid = 3;

Question 12

The AVG function can be used with ____ values.​

Accepted Answer

A)  ​numeric 
B)  ​character 
C)  ​date 
D)  ​all of the above 
A)  ​numeric 
B)  ​character 
C)  ​date 
D)  ​all of the above

Question 13

By default,the COUNT function uses the DISTINCT keyword when counting the values contained in a column._________________________​

Accepted Answer

A) True 
 B)False

Question 14

Functions that return one result per group of rows are called ____ functions.​

Accepted Answer

A)  ​group 
B)  ​multiple-row 
C)  ​aggregate 
D)  ​all of the above 
A)  ​group 
B)  ​multiple-row 
C)  ​aggregate 
D)  ​all of the above

Question 15

The SUM function can only be used with ____ data.​

Accepted Answer

A)  ​numeric 
B)  ​character 
C)  ​date 
D)  ​alphanumeric 
A)  ​numeric 
B)  ​character 
C)  ​date 
D)  ​alphanumeric

Question 16

Contents of the BOOKS table​
  
-Based on the contents of the BOOKS table,which of the following will display the date of the book with the earliest publication date?​

Accepted Answer

A)  ​SELECT MIN(pubdate)
FROM books; 
B)  SELECT title
FROM books
WHERE pubdate = MIN(pubdate);​ 
C)  ​SELECT title
FROM books
WHERE pubdate = MINIMUM(pubdate); 
D)  ​SELECT MINIMUM(pubdate)
FROM books; 
A)  ​SELECT MIN(pubdate)
FROM books; 
B)  SELECT title
FROM books
WHERE pubdate = MIN(pubdate);​ 
C)  ​SELECT title
FROM books
WHERE pubdate = MINIMUM(pubdate); 
D)  ​SELECT MINIMUM(pubdate)
FROM books;

Question 17

​Describe how the COUNT function processes NULL values when the function is executed.

Accepted Answer

When the COUNT function includes an aste

Question 18

The WHERE clause specifies which groups will be displayed in the results.​

Accepted Answer

A) True 
 B)False

Question 19

Group functions return a group of results per row processed.​

Accepted Answer

A) True 
 B)False

Question 20

​The ____________________ clause can be used to restrict rows,but not groups.

Accepted Answer

The answer of ​The ____________________ clause can be used to...

Which of the following can be used with character data?

If the DISTINCT keyword is not included in the STDDEV function,the ____ keyword will be assumed.

Group functions can only be nested to a depth of two.

Which of the following cannot be used with date columns?

When a SELECT statement contains WHERE,GROUP BY,and HAVING clauses,the ____________________ clause is always evaluated first.

AVG,COUNT,and STDDEV are all considered group functions.

The HAVING clause serves as the WHERE clause for aggregated data._________________________

Column aliases can be used in the GROUP BY clause.

The ____________________ function is used to determine how widely the numeric data contained within a specified column is spread out.

The ____ function can be used to determine the largest value stored in a specified column.

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following will display the retail price of the most expensive book provided by publisher 3?

The AVG function can be used with ____ values.

By default,the COUNT function uses the DISTINCT keyword when counting the values contained in a column._________________________

Functions that return one result per group of rows are called ____ functions.

The SUM function can only be used with ____ data.

Contents of the BOOKS table -Based on the contents of the BOOKS table,which of the following will display the date of the book with the earliest publication date?

Describe how the COUNT function processes NULL values when the function is executed.

The WHERE clause specifies which groups will be displayed in the results.

Group functions return a group of results per row processed.

The ____________________ clause can be used to restrict rows,but not groups.

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Subqueries and Merge Statements

Views

Filters

Exam 11: Group Functions

​Which of the following can be used with character data?

If the DISTINCT keyword is not included in the STDDEV function,the ____ keyword will be assumed.​

Group functions can only be nested to a depth of two.​

Which of the following cannot be used with date columns?​

​When a SELECT statement contains WHERE,GROUP BY,and HAVING clauses,the ____________________ clause is always evaluated first.

AVG,COUNT,and STDDEV are all considered group functions.​

The HAVING clause serves as the WHERE clause for aggregated data._________________________​

Column aliases can be used in the GROUP BY clause.​

​The ____________________ function is used to determine how widely the numeric data contained within a specified column is spread out.

The ____ function can be used to determine the largest value stored in a specified column.​

Contents of the BOOKS table​ -Based upon the contents of the BOOKS table,which of the following will display the retail price of the most expensive book provided by publisher 3?​

The AVG function can be used with ____ values.​

By default,the COUNT function uses the DISTINCT keyword when counting the values contained in a column._________________________​

Functions that return one result per group of rows are called ____ functions.​

The SUM function can only be used with ____ data.​

Contents of the BOOKS table​ -Based on the contents of the BOOKS table,which of the following will display the date of the book with the earliest publication date?​

​Describe how the COUNT function processes NULL values when the function is executed.

The WHERE clause specifies which groups will be displayed in the results.​

Group functions return a group of results per row processed.​

​The ____________________ clause can be used to restrict rows,but not groups.

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Subqueries and Merge Statements

Views

Filters

Which of the following can be used with character data?

If the DISTINCT keyword is not included in the STDDEV function,the ____ keyword will be assumed.

Group functions can only be nested to a depth of two.

Which of the following cannot be used with date columns?

When a SELECT statement contains WHERE,GROUP BY,and HAVING clauses,the ____________________ clause is always evaluated first.

AVG,COUNT,and STDDEV are all considered group functions.

The HAVING clause serves as the WHERE clause for aggregated data._________________________

Column aliases can be used in the GROUP BY clause.

The ____________________ function is used to determine how widely the numeric data contained within a specified column is spread out.

The ____ function can be used to determine the largest value stored in a specified column.

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following will display the retail price of the most expensive book provided by publisher 3?

The AVG function can be used with ____ values.

By default,the COUNT function uses the DISTINCT keyword when counting the values contained in a column._________________________

Functions that return one result per group of rows are called ____ functions.

The SUM function can only be used with ____ data.

Contents of the BOOKS table -Based on the contents of the BOOKS table,which of the following will display the date of the book with the earliest publication date?

Describe how the COUNT function processes NULL values when the function is executed.

The WHERE clause specifies which groups will be displayed in the results.

Group functions return a group of results per row processed.

The ____________________ clause can be used to restrict rows,but not groups.