Question 1

​The MIN function can be used with the DISTINCT or ALL keywords._________________________

Accepted Answer

A) True 
 B)False

Question 2

The ORDER BY clause is used to group data._________________________​

Accepted Answer

A) True 
 B)False

Question 3

​The ____________________ clause is used to group data based upon a specified column or columns.

Accepted Answer

The answer of ​The ____________________ clause is used to group...

Question 4

The ____ function can be used to include NULL values in a calculation.​

Accepted Answer

A)  ​AVG 
B)  ​SUM 
C)  ​NULL 
D)  ​NVL 
A)  ​AVG 
B)  ​SUM 
C)  ​NULL 
D)  ​NVL

Question 5

The MAX function can be used with which type of columns?​

Accepted Answer

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

Question 6

If the output is to be restricted based upon a group function,a(n)____ clause must be included in the SQL statement.​

Accepted Answer

A)  ​GROUP BY 
B)  ​WHERE 
C)  ​HAVING 
D)  ​ORDER BY 
A)  ​GROUP BY 
B)  ​WHERE 
C)  ​HAVING 
D)  ​ORDER BY

Question 7

​The SUM function can only be used with ____________________ columns.

Accepted Answer

The answer of ​The SUM function can only be used...

Question 8

The GROUP BY clause can only be used when a SELECT statement includes a group function.​

Accepted Answer

A) True 
 B)False

Question 9

The ____ function can be used to determine the number of rows meeting a specific condition.​

Accepted Answer

A)  ​ADD 
B)  ​SUM 
C)  ​COUNT 
D)  ​TOTAL 
A)  ​ADD 
B)  ​SUM 
C)  ​COUNT 
D)  ​TOTAL

Question 10

​The ____________________ keyword can be used with the COUNT function to specify that only unique occurrences should be included in the results.

Accepted Answer

The answer of ​The ____________________ keyword can be used with...

Question 11

The default keyword for group functions is ____.​

Accepted Answer

A)  ​ALL 
B)  DISTINCT 
C)  ​INCLUDENULLS 
D)  ​NONULLS 
A)  ​ALL 
B)  DISTINCT 
C)  ​INCLUDENULLS 
D)  ​NONULLS

Question 12

Results returned from a SELECT statement that include a GROUP BY clause will present the results in descending order of the column(s)listed in the GROUP BY clause._________________________​

Accepted Answer

A) True 
 B)False

Question 13

The HAVING clause is used to restrict the groups returned by a query.​

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is a correct statement?​

Accepted Answer

A)  ​An asterisk can be used as the argument for the COUNT function to include NULL values in the results. 
B)  ​The NULL keyword can be included in the argument of the COUNT function to include NULL values in the results. 
C)  ​The ALL keyword can be included in the argument of the COUNT function to include NULL values in the results. 
D)  ​The INCLUDE NULLS keywords can be included in the argument for the COUNT function to include NULL values in the results. 
A)  ​An asterisk can be used as the argument for the COUNT function to include NULL values in the results. 
B)  ​The NULL keyword can be included in the argument of the COUNT function to include NULL values in the results. 
C)  ​The ALL keyword can be included in the argument of the COUNT function to include NULL values in the results. 
D)  ​The INCLUDE NULLS keywords can be included in the argument for the COUNT function to include NULL values in the results.

Question 15

The SUM function is used to calculate the total amount stored in a numeric field for a group of records.​

Accepted Answer

A) True 
 B)False

Question 16

When group functions are nested,the inner function is always resolved first._________________________​

Accepted Answer

A) True 
 B)False

Question 17

​The ____________________ keyword is used to indicate that only unique values should be included in the calculation performed by the SUM function.

Accepted Answer

The answer of ​The ____________________ keyword is used to indicate...

Question 18

If a group function is used in the SELECT clause,any ____ listed in the SELECT clause must also be listed in the GROUP BY clause.​

Accepted Answer

A)  ​aggregate function 
B)  ​single-row function 
C)  ​individual column 
D)  ​all of the above 
A)  ​aggregate function 
B)  ​single-row function 
C)  ​individual column 
D)  ​all of the above

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.​

Accepted Answer

A) True 
 B)False

The MIN function can be used with the DISTINCT or ALL keywords._________________________

The ORDER BY clause is used to group data._________________________

The ____________________ clause is used to group data based upon a specified column or columns.

The ____ function can be used to include NULL values in a calculation.

The MAX function can be used with which type of columns?

If the output is to be restricted based upon a group function,a(n)____ clause must be included in the SQL statement.

The SUM function can only be used with ____________________ columns.

The GROUP BY clause can only be used when a SELECT statement includes a group function.

The ____ function can be used to determine the number of rows meeting a specific condition.

The ____________________ keyword can be used with the COUNT function to specify that only unique occurrences should be included in the results.

The default keyword for group functions is ____.

Results returned from a SELECT statement that include a GROUP BY clause will present the results in descending order of the column(s)listed in the GROUP BY clause._________________________

The HAVING clause is used to restrict the groups returned by a query.

Which of the following is a correct statement?

The SUM function is used to calculate the total amount stored in a numeric field for a group of records.

When group functions are nested,the inner function is always resolved first._________________________

The ____________________ keyword is used to indicate that only unique values should be included in the calculation performed by the SUM function.

If a group function is used in the SELECT clause,any ____ listed in the SELECT clause must also be listed in the GROUP BY clause.

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

Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.

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

​The MIN function can be used with the DISTINCT or ALL keywords._________________________

The ORDER BY clause is used to group data._________________________​

​The ____________________ clause is used to group data based upon a specified column or columns.

The ____ function can be used to include NULL values in a calculation.​

The MAX function can be used with which type of columns?​

If the output is to be restricted based upon a group function,a(n)____ clause must be included in the SQL statement.​

​The SUM function can only be used with ____________________ columns.

The GROUP BY clause can only be used when a SELECT statement includes a group function.​

The ____ function can be used to determine the number of rows meeting a specific condition.​

​The ____________________ keyword can be used with the COUNT function to specify that only unique occurrences should be included in the results.

The default keyword for group functions is ____.​

Results returned from a SELECT statement that include a GROUP BY clause will present the results in descending order of the column(s)listed in the GROUP BY clause._________________________​

The HAVING clause is used to restrict the groups returned by a query.​

Which of the following is a correct statement?​

The SUM function is used to calculate the total amount stored in a numeric field for a group of records.​

When group functions are nested,the inner function is always resolved first._________________________​

​The ____________________ keyword is used to indicate that only unique values should be included in the calculation performed by the SUM function.

If a group function is used in the SELECT clause,any ____ listed in the SELECT clause must also be listed in the GROUP BY clause.​

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

Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.​

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

The MIN function can be used with the DISTINCT or ALL keywords._________________________

The ORDER BY clause is used to group data._________________________

The ____________________ clause is used to group data based upon a specified column or columns.

The ____ function can be used to include NULL values in a calculation.

The MAX function can be used with which type of columns?

If the output is to be restricted based upon a group function,a(n)____ clause must be included in the SQL statement.

The SUM function can only be used with ____________________ columns.

The GROUP BY clause can only be used when a SELECT statement includes a group function.

The ____ function can be used to determine the number of rows meeting a specific condition.

The ____________________ keyword can be used with the COUNT function to specify that only unique occurrences should be included in the results.

The default keyword for group functions is ____.

Results returned from a SELECT statement that include a GROUP BY clause will present the results in descending order of the column(s)listed in the GROUP BY clause._________________________

The HAVING clause is used to restrict the groups returned by a query.

Which of the following is a correct statement?

The SUM function is used to calculate the total amount stored in a numeric field for a group of records.

When group functions are nested,the inner function is always resolved first._________________________

The ____________________ keyword is used to indicate that only unique values should be included in the calculation performed by the SUM function.

If a group function is used in the SELECT clause,any ____ listed in the SELECT clause must also be listed in the GROUP BY clause.

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

Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.