Question 1

Group functions return one result per group of rows processed.

Accepted Answer

A) True 
 B)False

Question 2

The ____________________ function is used to calculate the average of the numeric values in a specified column.

Accepted Answer

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

Question 3

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 4

The COUNT(*) function is only used to count the number of records containing NULL values.

Accepted Answer

A) True 
 B)False

Question 5

Group functions can be nested inside $\underline { \text { single-row } }$functions. _________________________

Accepted Answer

A) True 
 B)False

Question 6

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 7

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...

Question 8

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 9

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 10

Contents of the ORDERS table
  
-Based on the contents of the ORDERS table, which of the following SQL statements will display the number of orders that have not been shipped?

Accepted Answer

A)  SELECT order#, COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL; 
B)  SELECT order#, COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL
GROUP BY order#; 
C)  SELECT COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL; 
D)  SELECT COUNT(*)
FROM orders
WHERE shipdate IS NULL; 
A)  SELECT order#, COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL; 
B)  SELECT order#, COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL
GROUP BY order#; 
C)  SELECT COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL; 
D)  SELECT COUNT(*)
FROM orders
WHERE shipdate IS NULL;

Question 11

By default, the AVG function assumes the ____________________ keyword, which indicates that all values should be included in the calculation.

Accepted Answer

The answer of By default, the AVG function assumes the...

Question 12

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 13

When group functions are nested, the$\underline { \text { inner } }$ function is always resolved first. _________________________

Accepted Answer

A) True 
 B)False

Question 14

The $\underline { \text { AVG } }$ function only includes non-NULL values in its calculations. _________________________

Accepted Answer

A) True 
 B)False

Question 15

By default, the COUNT function uses the $\underline {\text { DISTINCT } }$keyword when counting the values contained in a column. _________________________

Accepted Answer

A) True 
 B)False

Question 16

The STDVAR function is used to determine the standard deviation of numeric data.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is a valid SQL statement?

Accepted Answer

A)  SELECT SUM(quantity*retail) "Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
WHERE orderdate = '02-APR-03'; 
B)  SELECT SUM(quantity*retail) "Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'; 
C)  SELECT customer#, SUM(quantity*retail) "Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'; 
D)  SELECT customer#, SUM(quantity*retail) "Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'
GROUP BY customer#; 
A)  SELECT SUM(quantity*retail) "Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
WHERE orderdate = '02-APR-03'; 
B)  SELECT SUM(quantity*retail) "Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'; 
C)  SELECT customer#, SUM(quantity*retail) "Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'; 
D)  SELECT customer#, SUM(quantity*retail) "Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'
GROUP BY customer#;

Question 19

$\underline { \text { Single-row } }$ functions return one result per group of rows processed. _________________________

Accepted Answer

A) True 
 B)False

Question 20

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...

Group functions return one result per group of rows processed.

The ____________________ function is used to calculate the average of the numeric values in a specified column.

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

The COUNT(*) function is only used to count the number of records containing NULL values.

Group functions can be nested inside $\underline { \text { single-row } }$ functions. _________________________

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.

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

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?

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 SQL statements will display the number of orders that have not been shipped?

By default, the AVG function assumes the ____________________ keyword, which indicates that all values should be included in the calculation.

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?

When group functions are nested, the $\underline { \text { inner } }$ function is always resolved first. _________________________

The $\underline { \text { AVG } }$ function only includes non-NULL values in its calculations. _________________________

By default, the COUNT function uses the $\underline {\text { DISTINCT } }$ keyword when counting the values contained in a column. _________________________

The STDVAR function is used to determine the standard deviation of numeric data.

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

Which of the following is a valid SQL statement?

$\underline { \text { Single-row } }$ functions return one result per group of rows processed. _________________________

The ____________________ keyword is used to indicate that only unique values should be included in the calculation performed by the SUM 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

Group functions return one result per group of rows processed.

The ____________________ function is used to calculate the average of the numeric values in a specified column.

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

The COUNT(*) function is only used to count the number of records containing NULL values.

Group functions can be nested inside single-row ‾\underline { \text { single-row } } single-row ​ functions. _________________________

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.

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

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?

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 SQL statements will display the number of orders that have not been shipped?

By default, the AVG function assumes the ____________________ keyword, which indicates that all values should be included in the calculation.

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?

When group functions are nested, the inner ‾\underline { \text { inner } } inner ​ function is always resolved first. _________________________

The AVG ‾\underline { \text { AVG } } AVG ​ function only includes non-NULL values in its calculations. _________________________

By default, the COUNT function uses the DISTINCT ‾\underline {\text { DISTINCT } } DISTINCT ​ keyword when counting the values contained in a column. _________________________

The STDVAR function is used to determine the standard deviation of numeric data.

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

Which of the following is a valid SQL statement?

Single-row ‾\underline { \text { Single-row } } Single-row ​ functions return one result per group of rows processed. _________________________

The ____________________ keyword is used to indicate that only unique values should be included in the calculation performed by the SUM 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

Group functions can be nested inside $\underline { \text { single-row } }$ functions. _________________________

When group functions are nested, the $\underline { \text { inner } }$ function is always resolved first. _________________________

The $\underline { \text { AVG } }$ function only includes non-NULL values in its calculations. _________________________

By default, the COUNT function uses the $\underline {\text { DISTINCT } }$ keyword when counting the values contained in a column. _________________________

$\underline { \text { Single-row } }$ functions return one result per group of rows processed. _________________________