Question 1

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 2

A(n) ____________________ should be included as the argument for the COUNT function to include NULL values in the results.

Accepted Answer

*
asterisk

Question 3

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 4

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 $\underline { \text { ORDER BY } }$ clause. _________________________

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

The $\underline {\text { GROUP BY } }$ clause is used to restrict the groups returned by a query. _________________________

Accepted Answer

A) True 
 B)False

Question 8

The MAX function can be used with character data.

Accepted Answer

A) True 
 B)False

Question 9

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 10

If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed first.

Accepted Answer

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

Question 11

Describe how the COUNT function processes NULL values when the function is executed.

Accepted Answer

When the COUNT function includes an aste

Question 12

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 13

The WHERE clause filters the data before grouping, while the HAVING clause filters the groups $\underline { \text { after } }$grouping is performed. _________________________

Accepted Answer

A) True 
 B)False

Question 14

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 15

Contents of the BOOKS table
  
-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

Question 16

Column aliases can be used in the GROUP BY clause.

Accepted Answer

A) True 
 B)False

Question 17

The COUNT function can only be used for numeric columns.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The $\underline { \operatorname{COUNT}\left(^{*}\right) }$ function can be used to count the number of rows containing NULL and non-NULL values. _________________________

Accepted Answer

A) True 
 B)False

Question 20

Which of the following cannot be used with date columns?

Accepted Answer

A)  MIN 
B)  MAX 
C)  AVG 
D)  all of the above 
A)  MIN 
B)  MAX 
C)  AVG 
D)  all of the above

Which of the following is a valid statement?

A(n) ____________________ should be included as the argument for the COUNT function to include NULL values in the results.

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

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 $\underline { \text { ORDER BY } }$ clause. _________________________

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

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 $\underline {\text { GROUP BY } }$ clause is used to restrict the groups returned by a query. _________________________

The MAX function can be used with character data.

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

If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed first.

Describe how the COUNT function processes NULL values when the function is executed.

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

The WHERE clause filters the data before grouping, while the HAVING clause filters the groups $\underline { \text { after } }$ grouping is performed. _________________________

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

Contents of the BOOKS table -Which of the following can be used with date columns?

Column aliases can be used in the GROUP BY clause.

The COUNT function can only be used for numeric columns.

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

The $\underline { \operatorname{COUNT}\left(^{*}\right) }$ function can be used to count the number of rows containing NULL and non-NULL values. _________________________

Which of the following cannot be used with date 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

Which of the following is a valid statement?

A(n) ____________________ should be included as the argument for the COUNT function to include NULL values in the results.

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

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 ‾\underline { \text { ORDER BY } } ORDER BY ​ clause. _________________________

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

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 GROUP BY ‾\underline {\text { GROUP BY } } GROUP BY ​ clause is used to restrict the groups returned by a query. _________________________

The MAX function can be used with character data.

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

If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed first.

Describe how the COUNT function processes NULL values when the function is executed.

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

The WHERE clause filters the data before grouping, while the HAVING clause filters the groups after ‾\underline { \text { after } } after ​ grouping is performed. _________________________

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

Contents of the BOOKS table -Which of the following can be used with date columns?

Column aliases can be used in the GROUP BY clause.

The COUNT function can only be used for numeric columns.

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

The COUNT⁡(∗)‾\underline { \operatorname{COUNT}\left(^{*}\right) }COUNT(∗)​ function can be used to count the number of rows containing NULL and non-NULL values. _________________________

Which of the following cannot be used with date 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

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 $\underline { \text { ORDER BY } }$ clause. _________________________

The $\underline {\text { GROUP BY } }$ clause is used to restrict the groups returned by a query. _________________________

The WHERE clause filters the data before grouping, while the HAVING clause filters the groups $\underline { \text { after } }$ grouping is performed. _________________________

The $\underline { \operatorname{COUNT}\left(^{*}\right) }$ function can be used to count the number of rows containing NULL and non-NULL values. _________________________