Question 1

A group function can be nested inside a(n)____.​

Accepted Answer

A)  ​group function 
B)  ​single-row function 
C)  ​order function 
D)  ​both a and b 
A)  ​group function 
B)  ​single-row function 
C)  ​order function 
D)  ​both a and b

Question 2

SUM,AVG,and COUNT are all considered group functions._________________________​

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

​The ____________________ function can be used to count the total records that meet a specific condition,including those that contain NULL values.

Accepted Answer

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

Question 5

​The ____________________ function is used to determine the largest value stored in a specified column.

Accepted Answer

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

Question 6

The ____ clause is used to indicate that groups should be created.​

Accepted Answer

A)  ​ORDER BY 
B)  ​GROUP BY 
C)  ​AGGREGATED 
D)  ​GROUPING 
A)  ​ORDER BY 
B)  ​GROUP BY 
C)  ​AGGREGATED 
D)  ​GROUPING

Question 7

The ____ function is based upon the concept of a normal distribution.​

Accepted Answer

A)  ​MIN 
B)  ​MAX 
C)  ​SUM 
D)  ​STDDEV 
A)  ​MIN 
B)  ​MAX 
C)  ​SUM 
D)  ​STDDEV

Question 8

The ____ function is used to determine how widely data are spread out within a group.​

Accepted Answer

A)  ​STDDEV 
B)  ​STANDARDDEV 
C)  ​VARIANCE 
D)  ​VAR 
A)  ​STDDEV 
B)  ​STANDARDDEV 
C)  ​VARIANCE 
D)  ​VAR

Question 9

​If the data returned by the GROUP BY clause needs to be sorted in descending order,you must include a(n)____________________ clause in the SELECT statement.

Accepted Answer

The answer of ​If the data returned by the GROUP...

Question 10

The ____ function returns the smallest value in a specified column.​

Accepted Answer

A)  ​LOW 
B)  ​LOWEST 
C)  ​MIN 
D)  ​MINIMUM 
A)  ​LOW 
B)  ​LOWEST 
C)  ​MIN 
D)  ​MINIMUM

Question 11

Contents of the ORDERS table​
  
-​Based on the contents of the ORDERS table,which of the following SELECT statements will determine the number of orders placed by each customer?

Accepted Answer

A)  ​SELECT COUNT(DISTINCT(customer#))
FROM orders; 
B)  ​SELECT COUNT(*)
FROM orders; 
C)  ​SELECT customer#,COUNT(customer#)
FROM orders
GROUP BY customer#; 
D)  ​none of the above 
A)  ​SELECT COUNT(DISTINCT(customer#))
FROM orders; 
B)  ​SELECT COUNT(*)
FROM orders; 
C)  ​SELECT customer#,COUNT(customer#)
FROM orders
GROUP BY customer#; 
D)  ​none of the above

Question 12

Which of the following is a valid statement?​

Accepted Answer

A)  ​The ORDER BY clause cannot be used in a SELECT statement containing a GROUP BY clause. 
B)  ​Data returned from a GROUP BY clause will automatically be sorted in descending order. 
C)  ​Column aliases cannot be used in a GROUP BY clause. 
D)  ​Columns referenced in the GROUP BY clause must also be contained in the SELECT clause. 
A)  ​The ORDER BY clause cannot be used in a SELECT statement containing a GROUP BY clause. 
B)  ​Data returned from a GROUP BY clause will automatically be sorted in descending order. 
C)  ​Column aliases cannot be used in a GROUP BY clause. 
D)  ​Columns referenced in the GROUP BY clause must also be contained in the SELECT clause.

Question 13

​Explain the difference between a WHERE and a HAVING clause.

Accepted Answer

The HAVING clause is used to restrict th

Question 14

​Explain how nested group functions are processed.

Accepted Answer

When a SELECT statement contai

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

group
mult

Question 17

The STDDEV function can be used with ____ columns.​

Accepted Answer

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

A group function can be nested inside a(n)____.

SUM,AVG,and COUNT are all considered group functions._________________________

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

The ____________________ function can be used to count the total records that meet a specific condition,including those that contain NULL values.

The ____________________ function is used to determine the largest value stored in a specified column.

The ____ clause is used to indicate that groups should be created.

The ____ function is based upon the concept of a normal distribution.

The ____ function is used to determine how widely data are spread out within a group.

If the data returned by the GROUP BY clause needs to be sorted in descending order,you must include a(n)____________________ clause in the SELECT statement.

The ____ function returns the smallest value in a specified column.

Contents of the ORDERS table -Based on the contents of the ORDERS table,which of the following SELECT statements will determine the number of orders placed by each customer?

Which of the following is a valid statement?

Explain the difference between a WHERE and a HAVING clause.

Explain how nested group functions are processed.

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

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

The STDDEV function can be used with ____ columns.

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