Question 1

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

Accepted Answer

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

Question 2

Which of the following indicates the processing order for the indicated clauses?​

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

​If a SELECT statement contains a GROUP BY clause,but no ORDER BY clause,the results will be presented in ____________________ order based on the column(s)listed in the GROUP BY clause.

Accepted Answer

The answer of ​If a SELECT statement contains a GROUP...

Question 5

The ____ function can be used to determine the number of rows containing a specified value.​

Accepted Answer

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

Question 6

By default,the SUM function assumes the ALL keyword and the result will include multiple occurrences of numeric values.​

Accepted Answer

A) True 
 B)False

Question 7

The optional DISTINCT keyword instructs Oracle12c to include only unique numeric values in the calculation._________________________​

Accepted Answer

A) True 
 B)False

Question 8

The WHERE clause filters the data before grouping,while the HAVING clause filters the groups after grouping is performed._________________________​

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The COUNT function is used to total the values stored in numeric columns._________________________​

Accepted Answer

A) True 
 B)False

Question 11

A(n)____ clause cannot include a group function.​

Accepted Answer

A)  ​WHERE 
B)  ​HAVING 
C)  ​SELECT 
D)  ​both a and c 
A)  ​WHERE 
B)  ​HAVING 
C)  ​SELECT 
D)  ​both a and c

Question 12

The DISTINCT keyword cannot be used with the MAX function.​

Accepted Answer

A) True 
 B)False

Question 13

If a group function is used in the SELECT clause,then any individual columns listed in the SELECT clause must also be listed in the ORDER BY clause._________________________​

Accepted Answer

A) True 
 B)False

Question 14

Contents of the BOOKS table​
  
-Based upon the contents of the BOOKS tables,which of the following SQL statements will return the number of different publishers represented in the table?​

Accepted Answer

A)  ​SELECT COUNT(DISTINCT pubid)FROM books; 
B)  ​SELECT DISTINCT COUNT(pubid)FROM books; 
C)  ​SELECT DISTINCT (COUNT(pubid))FROM books; 
D)  ​SELECT (DISTINCT COUNT(pubid))FROM books; 
A)  ​SELECT COUNT(DISTINCT pubid)FROM books; 
B)  ​SELECT DISTINCT COUNT(pubid)FROM books; 
C)  ​SELECT DISTINCT (COUNT(pubid))FROM books; 
D)  ​SELECT (DISTINCT COUNT(pubid))FROM books;

Question 15

The COUNT function can only be used for numeric columns.​

Accepted Answer

A) True 
 B)False

Question 16

The MAX functions returns the smallest value stored in the specified column._________________________​

Accepted Answer

A) True 
 B)False

Question 17

Contents of the ORDERS table​
  
-​Based upon the contents of the ORDERS table,which of the following will display how many orders were shipped to each state?

Accepted Answer

A)  ​SELECT shipstate,COUNT(*)
FROM orders; 
B)  ​SELECT shipstate,COUNT(customer#)
FROM orders; 
C)  ​SELECT shipstate,COUNT(*)
FROM orders
HAVING COUNT(*)>0 
D)  ​SELECT shipstate,COUNT(*)
FROM orders
GROUP BY shipstate; 
A)  ​SELECT shipstate,COUNT(*)
FROM orders; 
B)  ​SELECT shipstate,COUNT(customer#)
FROM orders; 
C)  ​SELECT shipstate,COUNT(*)
FROM orders
HAVING COUNT(*)>0 
D)  ​SELECT shipstate,COUNT(*)
FROM orders
GROUP BY shipstate;

Question 18

Which of the following is not considered a group function?​

Accepted Answer

A)  ​TRUNC 
B)  ​MIN 
C)  ​COUNT 
D)  ​SUM 
A)  ​TRUNC 
B)  ​MIN 
C)  ​COUNT 
D)  ​SUM

Question 19

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

Accepted Answer

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

Question 20

The ____ function calculates the standard deviation for a specific set of data.​

Accepted Answer

A)  ​STDDEVIATION 
B)  ​STD 
C)  ​STDDEV 
D)  ​STANDARDDEV 
A)  ​STDDEVIATION 
B)  ​STD 
C)  ​STDDEV 
D)  ​STANDARDDEV

Which of the following can be used with date columns?

Which of the following indicates the processing order for the indicated clauses?

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

If a SELECT statement contains a GROUP BY clause,but no ORDER BY clause,the results will be presented in ____________________ order based on the column(s)listed in the GROUP BY clause.

The ____ function can be used to determine the number of rows containing a specified value.

By default,the SUM function assumes the ALL keyword and the result will include multiple occurrences of numeric values.

The optional DISTINCT keyword instructs Oracle12c to include only unique numeric values in the calculation._________________________

The WHERE clause filters the data before grouping,while the HAVING clause filters the groups after grouping is performed._________________________

If a group function is used in the WHERE clause,then any individual columns listed in the SELECT clause must also be listed in the GROUP BY clause.

The COUNT function is used to total the values stored in numeric columns._________________________

A(n)____ clause cannot include a group function.

The DISTINCT keyword cannot be used with the MAX function.

If a group function is used in the SELECT clause,then any individual columns listed in the SELECT clause must also be listed in the ORDER BY clause._________________________

Contents of the BOOKS table -Based upon the contents of the BOOKS tables,which of the following SQL statements will return the number of different publishers represented in the table?

The COUNT function can only be used for numeric columns.

The MAX functions returns the smallest value stored in the specified column._________________________

Contents of the ORDERS table -Based upon the contents of the ORDERS table,which of the following will display how many orders were shipped to each state?

Which of the following is not considered a group function?

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

The ____ function calculates the standard deviation for a specific set of data.

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 date columns?

Which of the following indicates the processing order for the indicated clauses?​

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

​If a SELECT statement contains a GROUP BY clause,but no ORDER BY clause,the results will be presented in ____________________ order based on the column(s)listed in the GROUP BY clause.

The ____ function can be used to determine the number of rows containing a specified value.​

By default,the SUM function assumes the ALL keyword and the result will include multiple occurrences of numeric values.​

The optional DISTINCT keyword instructs Oracle12c to include only unique numeric values in the calculation._________________________​

The WHERE clause filters the data before grouping,while the HAVING clause filters the groups after grouping is performed._________________________​

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

The COUNT function is used to total the values stored in numeric columns._________________________​

A(n)____ clause cannot include a group function.​

The DISTINCT keyword cannot be used with the MAX function.​

If a group function is used in the SELECT clause,then any individual columns listed in the SELECT clause must also be listed in the ORDER BY clause._________________________​

Contents of the BOOKS table​ -Based upon the contents of the BOOKS tables,which of the following SQL statements will return the number of different publishers represented in the table?​

The COUNT function can only be used for numeric columns.​

The MAX functions returns the smallest value stored in the specified column._________________________​

Contents of the ORDERS table​ -​Based upon the contents of the ORDERS table,which of the following will display how many orders were shipped to each state?

Which of the following is not considered a group function?​

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

The ____ function calculates the standard deviation for a specific set of data.​

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 date columns?

Which of the following indicates the processing order for the indicated clauses?

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

If a SELECT statement contains a GROUP BY clause,but no ORDER BY clause,the results will be presented in ____________________ order based on the column(s)listed in the GROUP BY clause.

The ____ function can be used to determine the number of rows containing a specified value.

By default,the SUM function assumes the ALL keyword and the result will include multiple occurrences of numeric values.

The optional DISTINCT keyword instructs Oracle12c to include only unique numeric values in the calculation._________________________

The WHERE clause filters the data before grouping,while the HAVING clause filters the groups after grouping is performed._________________________

If a group function is used in the WHERE clause,then any individual columns listed in the SELECT clause must also be listed in the GROUP BY clause.

The COUNT function is used to total the values stored in numeric columns._________________________

A(n)____ clause cannot include a group function.

The DISTINCT keyword cannot be used with the MAX function.

If a group function is used in the SELECT clause,then any individual columns listed in the SELECT clause must also be listed in the ORDER BY clause._________________________

Contents of the BOOKS table -Based upon the contents of the BOOKS tables,which of the following SQL statements will return the number of different publishers represented in the table?

The COUNT function can only be used for numeric columns.

The MAX functions returns the smallest value stored in the specified column._________________________

Contents of the ORDERS table -Based upon the contents of the ORDERS table,which of the following will display how many orders were shipped to each state?

Which of the following is not considered a group function?

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

The ____ function calculates the standard deviation for a specific set of data.