Question 1

Which of the following is a valid statement?​

Accepted Answer

A)  ​A single-row function can be nested inside a group function. 
B)  ​Group functions can be nested inside other group functions. 
C)  ​Group functions can be nested inside single-row functions. 
D)  ​all of the above 
A)  ​A single-row function can be nested inside a group function. 
B)  ​Group functions can be nested inside other group functions. 
C)  ​Group functions can be nested inside single-row functions. 
D)  ​all of the above

Question 2

Group functions are also known as aggregate functions.​

Accepted Answer

A) True 
 B)False

Question 3

​If both nonaggregated and aggregated columns are used in the SELECT clause,the GROUP BY clause must contain the nonaggregated columns.

Accepted Answer

A) True 
 B)False

Question 4

​The ____________________ function can be used to determine the smallest value in a specified column.

Accepted Answer

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

Question 5

Contents of the BOOKS table​
  
-Based upon the contents of the BOOKS table,which of the following will determine the number of books provided by publisher 3?​

Accepted Answer

A)  ​SELECT SUM(isbn)
FROM books
WHERE pubid = 3; 
B)  ​SELECT TOTAL(*)
FROM books
WHERE pubid = 3; 
C)  SELECT COUNT(pubid)
FROM books
WHERE pubid = 3; 
D)  ​none of the above 
A)  ​SELECT SUM(isbn)
FROM books
WHERE pubid = 3; 
B)  ​SELECT TOTAL(*)
FROM books
WHERE pubid = 3; 
C)  SELECT COUNT(pubid)
FROM books
WHERE pubid = 3; 
D)  ​none of the above

Question 6

The VAR function is used to determine the variance contained within a set of data._________________________​

Accepted Answer

A) True 
 B)False

Question 7

Group functions return one result per group of rows processed.

Accepted Answer

A) True 
 B)False

Question 8

The ____________________ function is used to calculate the standard deviation for a column.

Accepted Answer

The answer of The ____________________ function is used to calculate...

Question 9

The only group function that includes NULL values by default is the MIN function.​

Accepted Answer

A) True 
 B)False

Question 10

The VARIANCE function can be used with ____ columns.​

Accepted Answer

A)  ​alphanumeric 
B)  ​numeric 
C)  ​date 
D)  ​none of the above 
A)  ​alphanumeric 
B)  ​numeric 
C)  ​date 
D)  ​none of the above

Question 11

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

Accepted Answer

The answer of ​Group functions can only be nested to...

Question 12

The MIN function is used to determine the smallest value in a specified column.​

Accepted Answer

A) True 
 B)False

Question 13

The MAX function can only be used with numeric or date columns.​

Accepted Answer

A) True 
 B)False

Question 14

​If an individual column is listed in a SELECT clause,along with a group function,the column must also be included in a(n)____________________ clause.

Accepted Answer

The answer of ​If an individual column is listed in...

Question 15

The HAVING clause specifies which groups will be displayed in the results,while the WHERE clause restricts the records that are retrieved from the table for processing._________________________​

Accepted Answer

A) True 
 B)False

Question 16

The MIN function can be used with numeric,date,and character columns.​

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

Contents of the BOOKS table​
  
-Based on the contents of the BOOKS table,which of the following is a valid SQL statement?​

Accepted Answer

A)  ​SELECT pubid,AVERAGE(retail-cost)"Average Profit"
FROM books; 
B)  SELECT pubid,AVERAGE(retail-cost)"Average Profit"
FROM books
GROUP BY pubid;​ 
C)  ​SELECT pubid,AVG(retail-cost)"Average Profit"
FROM books
GROUP BY pubid; 
D)  ​SELECT pubid,AVG(retail-cost)"Average Profit"
FROM books
HAVING retail-cost > 25; 
A)  ​SELECT pubid,AVERAGE(retail-cost)"Average Profit"
FROM books; 
B)  SELECT pubid,AVERAGE(retail-cost)"Average Profit"
FROM books
GROUP BY pubid;​ 
C)  ​SELECT pubid,AVG(retail-cost)"Average Profit"
FROM books
GROUP BY pubid; 
D)  ​SELECT pubid,AVG(retail-cost)"Average Profit"
FROM books
HAVING retail-cost > 25;

Question 19

The MAX function can be used with character data.​

Accepted Answer

A) True 
 B)False

Question 20

The only group function that includes NULL values is the NVL function._________________________​

Accepted Answer

A) True 
 B)False

Which of the following is a valid statement?

Group functions are also known as aggregate functions.

If both nonaggregated and aggregated columns are used in the SELECT clause,the GROUP BY clause must contain the nonaggregated columns.

The ____________________ function can be used to determine the smallest value in a specified column.

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following will determine the number of books provided by publisher 3?

The VAR function is used to determine the variance contained within a set of data._________________________

Group functions return one result per group of rows processed.

The ____________________ function is used to calculate the standard deviation for a column.

The only group function that includes NULL values by default is the MIN function.

The VARIANCE function can be used with ____ columns.

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

The MIN function is used to determine the smallest value in a specified column.

The MAX function can only be used with numeric or date columns.

If an individual column is listed in a SELECT clause,along with a group function,the column must also be included in a(n)____________________ clause.

The HAVING clause specifies which groups will be displayed in the results,while the WHERE clause restricts the records that are retrieved from the table for processing._________________________

The MIN function can be used with numeric,date,and character columns.

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

Contents of the BOOKS table -Based on the contents of the BOOKS table,which of the following is a valid SQL statement?

The MAX function can be used with character data.

The only group function that includes NULL values is the NVL function._________________________

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 is a valid statement?​

Group functions are also known as aggregate functions.​

​If both nonaggregated and aggregated columns are used in the SELECT clause,the GROUP BY clause must contain the nonaggregated columns.

​The ____________________ function can be used to determine the smallest value in a specified column.

Contents of the BOOKS table​ -Based upon the contents of the BOOKS table,which of the following will determine the number of books provided by publisher 3?​

The VAR function is used to determine the variance contained within a set of data._________________________​

Group functions return one result per group of rows processed.

The ____________________ function is used to calculate the standard deviation for a column.

The only group function that includes NULL values by default is the MIN function.​

The VARIANCE function can be used with ____ columns.​

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

The MIN function is used to determine the smallest value in a specified column.​

The MAX function can only be used with numeric or date columns.​

​If an individual column is listed in a SELECT clause,along with a group function,the column must also be included in a(n)____________________ clause.

The HAVING clause specifies which groups will be displayed in the results,while the WHERE clause restricts the records that are retrieved from the table for processing._________________________​

The MIN function can be used with numeric,date,and character columns.​

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

Contents of the BOOKS table​ -Based on the contents of the BOOKS table,which of the following is a valid SQL statement?​

The MAX function can be used with character data.​

The only group function that includes NULL values is the NVL function._________________________​

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 is a valid statement?

Group functions are also known as aggregate functions.

If both nonaggregated and aggregated columns are used in the SELECT clause,the GROUP BY clause must contain the nonaggregated columns.

The ____________________ function can be used to determine the smallest value in a specified column.

Contents of the BOOKS table -Based upon the contents of the BOOKS table,which of the following will determine the number of books provided by publisher 3?

The VAR function is used to determine the variance contained within a set of data._________________________

The only group function that includes NULL values by default is the MIN function.

The VARIANCE function can be used with ____ columns.

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

The MIN function is used to determine the smallest value in a specified column.

The MAX function can only be used with numeric or date columns.

If an individual column is listed in a SELECT clause,along with a group function,the column must also be included in a(n)____________________ clause.

The HAVING clause specifies which groups will be displayed in the results,while the WHERE clause restricts the records that are retrieved from the table for processing._________________________

The MIN function can be used with numeric,date,and character columns.

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

Contents of the BOOKS table -Based on the contents of the BOOKS table,which of the following is a valid SQL statement?

The MAX function can be used with character data.

The only group function that includes NULL values is the NVL function._________________________