Question 1

The DISTINCT keyword cannot be used with the MAX function.

Accepted Answer

A) True 
 B)False

Question 2

When an SQL statement contains nested functions, the ____________________ function is always resolved first.

Accepted Answer

The answer of When an SQL statement contains nested functions,...

Question 3

Which of the following is a valid statement?

Accepted Answer

A)  A single-row function can be nested inside a group function. 
B)  Group functions can be nested inside other group functions. 
C)  Group functions can be nested inside single-row functions. 
D)  all of the above 
A)  A single-row function can be nested inside a group function. 
B)  Group functions can be nested inside other group functions. 
C)  Group functions can be nested inside single-row functions. 
D)  all of the above

Question 4

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 5

The WHERE clause specifies which groups will be displayed in the results.

Accepted Answer

A) True 
 B)False

Question 6

The SUM function is used to calculate the total amount stored in a numeric field for a group of records.

Accepted Answer

A) True 
 B)False

Question 7

A SELECT statement cannot include both a GROUP BY and an ORDER BY clause.

Accepted Answer

A) True 
 B)False

Question 8

If a group function is used in the SELECT clause, any ____ listed in the SELECT clause must also be listed in the GROUP BY clause.

Accepted Answer

A)  aggregate function 
B)  single-row function 
C)  individual column 
D)  all of the above 
A)  aggregate function 
B)  single-row function 
C)  individual column 
D)  all of the above

Question 9

The SUM function can only be used with ____ data.

Accepted Answer

A)  numeric 
B)  character 
C)  date 
D)  alphanumeric 
A)  numeric 
B)  character 
C)  date 
D)  alphanumeric

Question 10

The only group function that includes NULL values by default is the MIN function.

Accepted Answer

A) True 
 B)False

Question 11

Contents of the BOOKS table
  
-Based on the contents of the BOOKS table, which of the following SQL statements will return the total profit generated by books provided by publisher 4?

Accepted Answer

A)  SELECT TOTAL(retail-cost) FROM books
WHERE pubid = 4; 
B)  SELECT TOTAL(retail-cost) FROM books
GROUP BY pubid; 
C)  SELECT SUM(retail-cost) FROM books
WHERE pubid = 4; 
D)  SELECT SUM(retail-cost) FROM books
GROUP BY pubid = 4; 
A)  SELECT TOTAL(retail-cost) FROM books
WHERE pubid = 4; 
B)  SELECT TOTAL(retail-cost) FROM books
GROUP BY pubid; 
C)  SELECT SUM(retail-cost) FROM books
WHERE pubid = 4; 
D)  SELECT SUM(retail-cost) FROM books
GROUP BY pubid = 4;

Question 12

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

Accepted Answer

A)  UNIQUE 
B)  ALL 
C)  NULLS ONLY 
D)  NONULLS 
A)  UNIQUE 
B)  ALL 
C)  NULLS ONLY 
D)  NONULLS

Question 13

By default, the AVG function will include NULL values when calculating the average of the numeric values in a specified column.

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

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 16

Contents of the BOOKS table
  
-Which of the following can be used with character data?

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 17

The ____ function calculates the average of the numeric values in a specified column.

Accepted Answer

A)  AVG 
B)  AVERAGE 
C)  MEAN 
D)  AG 
A)  AVG 
B)  AVERAGE 
C)  MEAN 
D)  AG

Question 18

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

Accepted Answer

A)  group 
B)  multiple-row 
C)  aggregate 
D)  all of the above 
A)  group 
B)  multiple-row 
C)  aggregate 
D)  all of the above

Question 19

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

Accepted Answer

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

Question 20

The MAX function can be used with the ____________________ keyword to ignore duplicate values.

Accepted Answer

The answer of The MAX function can be used with...

The DISTINCT keyword cannot be used with the MAX function.

When an SQL statement contains nested functions, the ____________________ function is always resolved first.

Which of the following is a valid statement?

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

The WHERE clause specifies which groups will be displayed in the results.

The SUM function is used to calculate the total amount stored in a numeric field for a group of records.

A SELECT statement cannot include both a GROUP BY and an ORDER BY clause.

If a group function is used in the SELECT clause, any ____ listed in the SELECT clause must also be listed in the GROUP BY clause.

The SUM function can only be used with ____ data.

The only group function that includes NULL values by default is the MIN function.

Contents of the BOOKS table -Based on the contents of the BOOKS table, which of the following SQL statements will return the total profit generated by books provided by publisher 4?

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

By default, the AVG function will include NULL values when calculating the average of the numeric values in a specified column.

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?

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

Contents of the BOOKS table -Which of the following can be used with character data?

The ____ function calculates the average of the numeric values in a specified column.

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

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

The MAX function can be used with the ____________________ keyword to ignore duplicate values.

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

The DISTINCT keyword cannot be used with the MAX function.

When an SQL statement contains nested functions, the ____________________ function is always resolved first.

Which of the following is a valid statement?

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

The WHERE clause specifies which groups will be displayed in the results.

The SUM function is used to calculate the total amount stored in a numeric field for a group of records.

A SELECT statement cannot include both a GROUP BY and an ORDER BY clause.

If a group function is used in the SELECT clause, any ____ listed in the SELECT clause must also be listed in the GROUP BY clause.

The SUM function can only be used with ____ data.

The only group function that includes NULL values by default is the MIN function.

Contents of the BOOKS table -Based on the contents of the BOOKS table, which of the following SQL statements will return the total profit generated by books provided by publisher 4?

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

By default, the AVG function will include NULL values when calculating the average of the numeric values in a specified column.

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?

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

Contents of the BOOKS table -Which of the following can be used with character data?

The ____ function calculates the average of the numeric values in a specified column.

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

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

The MAX function can be used with the ____________________ keyword to ignore duplicate values.

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