Question 1

If a group function is used in the WHERE clause, then any individual columns listed in the SELECT clause must also be listed in the GROUP BY clause.

Accepted Answer

A) True 
 B)False  False

Question 2

Columns used to group data in the $\underline { \text { GROUP BY } }$ clause do not have to be listed in the SELECT clause. _________________________

Accepted Answer

A) True 
 B)False  True

Question 3

Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

The answer of When a SELECT statement contains WHERE, GROUP...

Question 5

The ____ function can be used to determine the largest value stored in a specified column.

Accepted Answer

A)  MAXIMUM 
B)  MAX 
C)  LARGE 
D)  LARGEST 
A)  MAXIMUM 
B)  MAX 
C)  LARGE 
D)  LARGEST

Question 6

The optional $\underline { \text { DISTINCT } }$keyword instructs Oracle11g to include only unique numeric values in the calculation. _________________________

Accepted Answer

A) True 
 B)False

Question 7

Group functions can only be nested to a depth of two.

Accepted Answer

A) True 
 B)False

Question 8

Contents of the BOOKS table
  
-Based upon the contents of the BOOKS table, which of the following will determine the number of books provided by publisher 3?

Accepted Answer

A)  SELECT SUM(isbn)
FROM books
WHERE pubid = 3; 
B)  SELECT TOTAL(*)
FROM books
WHERE pubid = 3; 
C)  SELECT COUNT(pubid)
FROM books
WHERE pubid = 3; 
D)  none of the above 
A)  SELECT SUM(isbn)
FROM books
WHERE pubid = 3; 
B)  SELECT TOTAL(*)
FROM books
WHERE pubid = 3; 
C)  SELECT COUNT(pubid)
FROM books
WHERE pubid = 3; 
D)  none of the above

Question 9

The MIN function can be used with numeric, date, and character columns.

Accepted Answer

A) True 
 B)False

Question 10

Group functions are also known as aggregate functions.

Accepted Answer

A) True 
 B)False

Question 11

The $\underline {\text { MIN }}$function can be used with the DISTINCT or ALL keywords. _________________________

Accepted Answer

A) True 
 B)False

Question 12

The ____________________ function is used to calculate the standard deviation for a column.

Accepted Answer

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

Question 13

The ____ function calculates the standard deviation for a specific set of data.

Accepted Answer

A)  STDDEVIATION 
B)  STD 
C)  STDDEV 
D)  STANDARDDEV 
A)  STDDEVIATION 
B)  STD 
C)  STDDEV 
D)  STANDARDDEV

Question 14

The $\underline { \text { ORDER BY } }$ clause is used to group data. _________________________

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

group
mult

Question 16

A(n) ____ clause cannot include a group function.

Accepted Answer

A)  WHERE 
B)  HAVING 
C)  SELECT 
D)  both a and c 
A)  WHERE 
B)  HAVING 
C)  SELECT 
D)  both a and c

Question 17

If both nonaggregated and aggregated columns are used in the SELECT clause, the GROUP BY clause must contain the nonaggregated columns.

Accepted Answer

A) True 
 B)False

Question 18

The $\underline{\text { STDDEV }}$ function calculates the standard deviation for the data contained in a specified field. _________________________

Accepted Answer

A) True 
 B)False

Question 19

When a SELECT statement includes WHERE, HAVING, and GROUP BY clauses, the $\underline {\text { GROUP BY }}$ clause is always evaluated first. _________________________

Accepted Answer

A) True 
 B)False

Question 20

The MAX function can be used with which type of columns?

Accepted Answer

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

If a group function is used in the WHERE clause, then any individual columns listed in the SELECT clause must also be listed in the GROUP BY clause.

Columns used to group data in the $\underline { \text { GROUP BY } }$ clause do not have to be listed in the SELECT clause. _________________________

Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.

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

The ____ function can be used to determine the largest value stored in a specified column.

The optional $\underline { \text { DISTINCT } }$ keyword instructs Oracle11g to include only unique numeric values in the calculation. _________________________

Group functions can only be nested to a depth of two.

Contents of the BOOKS table -Based upon the contents of the BOOKS table, which of the following will determine the number of books provided by publisher 3?

The MIN function can be used with numeric, date, and character columns.

Group functions are also known as aggregate functions.

The $\underline {\text { MIN }}$ function can be used with the DISTINCT or ALL keywords. _________________________

The ____________________ function is used to calculate the standard deviation for a column.

The ____ function calculates the standard deviation for a specific set of data.

The $\underline { \text { ORDER BY } }$ clause is used to group data. _________________________

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

A(n) ____ clause cannot include a group function.

If both nonaggregated and aggregated columns are used in the SELECT clause, the GROUP BY clause must contain the nonaggregated columns.

The $\underline{\text { STDDEV }}$ function calculates the standard deviation for the data contained in a specified field. _________________________

When a SELECT statement includes WHERE, HAVING, and GROUP BY clauses, the $\underline {\text { GROUP BY }}$ clause is always evaluated first. _________________________

The MAX function can be used with which type of 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

If a group function is used in the WHERE clause, then any individual columns listed in the SELECT clause must also be listed in the GROUP BY clause.

Columns used to group data in the GROUP BY ‾\underline { \text { GROUP BY } } GROUP BY ​ clause do not have to be listed in the SELECT clause. _________________________

Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.

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

The ____ function can be used to determine the largest value stored in a specified column.

The optional DISTINCT ‾\underline { \text { DISTINCT } } DISTINCT ​ keyword instructs Oracle11g to include only unique numeric values in the calculation. _________________________

Group functions can only be nested to a depth of two.

Contents of the BOOKS table -Based upon the contents of the BOOKS table, which of the following will determine the number of books provided by publisher 3?

The MIN function can be used with numeric, date, and character columns.

Group functions are also known as aggregate functions.

The MIN ‾\underline {\text { MIN }} MIN ​ function can be used with the DISTINCT or ALL keywords. _________________________

The ____________________ function is used to calculate the standard deviation for a column.

The ____ function calculates the standard deviation for a specific set of data.

The ORDER BY ‾\underline { \text { ORDER BY } } ORDER BY ​ clause is used to group data. _________________________

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

A(n) ____ clause cannot include a group function.

If both nonaggregated and aggregated columns are used in the SELECT clause, the GROUP BY clause must contain the nonaggregated columns.

The STDDEV ‾\underline{\text { STDDEV }} STDDEV ​ function calculates the standard deviation for the data contained in a specified field. _________________________

When a SELECT statement includes WHERE, HAVING, and GROUP BY clauses, the GROUP BY ‾\underline {\text { GROUP BY }} GROUP BY ​ clause is always evaluated first. _________________________

The MAX function can be used with which type of 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

Columns used to group data in the $\underline { \text { GROUP BY } }$ clause do not have to be listed in the SELECT clause. _________________________

The optional $\underline { \text { DISTINCT } }$ keyword instructs Oracle11g to include only unique numeric values in the calculation. _________________________

The $\underline {\text { MIN }}$ function can be used with the DISTINCT or ALL keywords. _________________________

The $\underline { \text { ORDER BY } }$ clause is used to group data. _________________________

The $\underline{\text { STDDEV }}$ function calculates the standard deviation for the data contained in a specified field. _________________________

When a SELECT statement includes WHERE, HAVING, and GROUP BY clauses, the $\underline {\text { GROUP BY }}$ clause is always evaluated first. _________________________