Question 1

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 2

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 3

The GROUP BY clause is used to group data.

Accepted Answer

A) True 
 B)False

Question 4

The MAX functions returns the $\underline { \text { smallest }  }$ value stored in the specified column. _________________________

Accepted Answer

A) True 
 B)False

Question 5

The $\underline { \text { COUNT } }$ function is used to total the values stored in numeric columns. _________________________

Accepted Answer

A) True 
 B)False

Question 6

The VARIANCE function is used to determine the variance in a group of numeric data.

Accepted Answer

A) True 
 B)False

Question 7

If the output is to be restricted based upon a group function, a(n) ____ clause must be included in the SQL statement.

Accepted Answer

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

Question 8

Which of the following lines of the SQL statement contains an error? 1 SELECT title, MAX(retail)
2 FROM books
3 WHERE retail > 30
4 AND pubid = 1
5 GROUP BY retail;

Accepted Answer

A)  Line 2 
B)  Line 3 
C)  Line 4 
D)  Line 5 
A)  Line 2 
B)  Line 3 
C)  Line 4 
D)  Line 5

Question 9

The HAVING clause serves as the $\underline { \mathrm{WHERE} }$clause for aggregated data. _________________________

Accepted Answer

A) True 
 B)False

Question 10

The COUNT function can be used to count NULL, as well as, non-NULL values.

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Question 13

Explain how nested group functions are processed.

Accepted Answer

When a SELECT statement contai

Question 14

Contents of the BOOKS table
  
-Based on the contents of the BOOKS table, which of the following will display the date of the book with the earliest publication date?

Accepted Answer

A)  SELECT MIN(pubdate)
FROM books; 
B)  SELECT title
FROM books
WHERE pubdate = MIN(pubdate); 
C)  SELECT title
FROM books
WHERE pubdate = MINIMUM(pubdate); 
D)  SELECT MINIMUM(pubdate)
FROM books; 
A)  SELECT MIN(pubdate)
FROM books; 
B)  SELECT title
FROM books
WHERE pubdate = MIN(pubdate); 
C)  SELECT title
FROM books
WHERE pubdate = MINIMUM(pubdate); 
D)  SELECT MINIMUM(pubdate)
FROM books;

Question 15

SUM, AVG, and COUNT are all considered $\underline {\text { group } }$ functions. _________________________

Accepted Answer

A) True 
 B)False

Question 16

The ____________________ keyword can be used with the COUNT function to specify that only unique occurrences should be included in the results.

Accepted Answer

The answer of The ____________________ keyword can be used with...

Question 17

The ____________________ function is used to determine how widely the numeric data contained within a specified column is spread out.

Accepted Answer

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

Question 18

The MIN 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

Question 19

The $\underline { \text { VAR } }$ function is used to determine the variance contained within a set of data. _________________________

Accepted Answer

A) True 
 B)False

Question 20

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

Which of the following is not considered a group function?

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 GROUP BY clause is used to group data.

The MAX functions returns the $\underline { \text { smallest } }$ value stored in the specified column. _________________________

The $\underline { \text { COUNT } }$ function is used to total the values stored in numeric columns. _________________________

The VARIANCE function is used to determine the variance in a group of numeric data.

If the output is to be restricted based upon a group function, a(n) ____ clause must be included in the SQL statement.

Which of the following lines of the SQL statement contains an error? 1 SELECT title, MAX(retail) 2 FROM books 3 WHERE retail > 30 4 AND pubid = 1 5 GROUP BY retail;

The HAVING clause serves as the $\underline { \mathrm{WHERE} }$ clause for aggregated data. _________________________

The COUNT function can be used to count NULL, as well as, non-NULL values.

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

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

Explain how nested group functions are processed.

Contents of the BOOKS table -Based on the contents of the BOOKS table, which of the following will display the date of the book with the earliest publication date?

SUM, AVG, and COUNT are all considered $\underline {\text { group } }$ functions. _________________________

The ____________________ keyword can be used with the COUNT function to specify that only unique occurrences should be included in the results.

The ____________________ function is used to determine how widely the numeric data contained within a specified column is spread out.

The MIN function can be used with ____ columns.

The $\underline { \text { VAR } }$ function is used to determine the variance contained within a set of data. _________________________

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

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 not considered a group function?

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 GROUP BY clause is used to group data.

The MAX functions returns the smallest ‾\underline { \text { smallest } } smallest ​ value stored in the specified column. _________________________

The COUNT ‾\underline { \text { COUNT } } COUNT ​ function is used to total the values stored in numeric columns. _________________________

The VARIANCE function is used to determine the variance in a group of numeric data.

If the output is to be restricted based upon a group function, a(n) ____ clause must be included in the SQL statement.

Which of the following lines of the SQL statement contains an error? 1 SELECT title, MAX(retail) 2 FROM books 3 WHERE retail > 30 4 AND pubid = 1 5 GROUP BY retail;

The HAVING clause serves as the WHERE‾\underline { \mathrm{WHERE} }WHERE​ clause for aggregated data. _________________________

The COUNT function can be used to count NULL, as well as, non-NULL values.

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

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

Explain how nested group functions are processed.

Contents of the BOOKS table -Based on the contents of the BOOKS table, which of the following will display the date of the book with the earliest publication date?

SUM, AVG, and COUNT are all considered group ‾\underline {\text { group } } group ​ functions. _________________________

The ____________________ keyword can be used with the COUNT function to specify that only unique occurrences should be included in the results.

The ____________________ function is used to determine how widely the numeric data contained within a specified column is spread out.

The MIN function can be used with ____ columns.

The VAR ‾\underline { \text { VAR } } VAR ​ function is used to determine the variance contained within a set of data. _________________________

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

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

The MAX functions returns the $\underline { \text { smallest } }$ value stored in the specified column. _________________________

The $\underline { \text { COUNT } }$ function is used to total the values stored in numeric columns. _________________________

The HAVING clause serves as the $\underline { \mathrm{WHERE} }$ clause for aggregated data. _________________________

SUM, AVG, and COUNT are all considered $\underline {\text { group } }$ functions. _________________________

The $\underline { \text { VAR } }$ function is used to determine the variance contained within a set of data. _________________________