Question 1

The optional UNIQUE keyword instructs Oracle 11g to include only unique numeric values in its calculation.

Accepted Answer

A) True 
 B)False

Question 2

The WHERE clause $\underline { \text { can } }$ contain group functions. _________________________

Accepted Answer

A) True 
 B)False

Question 3

The ____________________ function can be used to count the total records that meet a specific condition, including those that contain NULL values.

Accepted Answer

The answer of The ____________________ function can be used to...

Question 4

Which of the following is a correct statement?

Accepted Answer

A)  An asterisk can be used as the argument for the COUNT function to include NULL values in the results. 
B)  The NULL keyword can be included in the argument of the COUNT function to include NULL values in the results. 
C)  The ALL keyword can be included in the argument of the COUNT function to include NULL values in the results. 
D)  The INCLUDE NULLS keywords can be included in the argument for the COUNT function to include NULL values in the results. 
A)  An asterisk can be used as the argument for the COUNT function to include NULL values in the results. 
B)  The NULL keyword can be included in the argument of the COUNT function to include NULL values in the results. 
C)  The ALL keyword can be included in the argument of the COUNT function to include NULL values in the results. 
D)  The INCLUDE NULLS keywords can be included in the argument for the COUNT function to include NULL values in the results.

Question 5

The VARIANCE function can be used with ____ columns.

Accepted Answer

A)  alphanumeric 
B)  numeric 
C)  date 
D)  none of the above 
A)  alphanumeric 
B)  numeric 
C)  date 
D)  none of the above

Question 6

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

Accepted Answer

The answer of Group functions can only be nested to...

Question 7

The $\underline { \text { TOTAL } }$ function is used to calculate the total value stored in a numeric field for a group of records. _________________________

Accepted Answer

A) True 
 B)False

Question 8

The ____________________ function can be used to determine the number of rows that have non-NULL values in a specified column.

Accepted Answer

The answer of The ____________________ function can be used to...

Question 9

The ____________________ clause can be used to restrict rows, but not groups.

Accepted Answer

The answer of The ____________________ clause can be used to...

Question 10

The GROUP BY clause can only be used when a SELECT statement includes a group function.

Accepted Answer

A) True 
 B)False

Question 11

Results returned from a SELECT statement that include a GROUP BY clause will present the results in $\underline { \text { descending } }$ order of the column(s) listed in the GROUP BY clause. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Contents of the ORDERS table
  
-Based on the contents of the ORDERS table, which of the following SELECT statements will determine the number of orders placed by each customer?

Accepted Answer

A)  SELECT COUNT(DISTINCT(customer#))
FROM orders; 
B)  SELECT COUNT(*)
FROM orders; 
C)  SELECT customer#, COUNT(customer#)
FROM orders
GROUP BY customer#; 
D)  none of the above 
A)  SELECT COUNT(DISTINCT(customer#))
FROM orders; 
B)  SELECT COUNT(*)
FROM orders; 
C)  SELECT customer#, COUNT(customer#)
FROM orders
GROUP BY customer#; 
D)  none of the above

Question 13

The ____ function can be used to determine the number of rows containing a specified value.

Accepted Answer

A)  TOTAL 
B)  SUM 
C)  COUNT 
D)  ADD 
A)  TOTAL 
B)  SUM 
C)  COUNT 
D)  ADD

Question 14

The ____ function is based upon the concept of a normal distribution.

Accepted Answer

A)  MIN 
B)  MAX 
C)  SUM 
D)  STDDEV 
A)  MIN 
B)  MAX 
C)  SUM 
D)  STDDEV

The optional UNIQUE keyword instructs Oracle 11g to include only unique numeric values in its calculation.

The WHERE clause $\underline { \text { can } }$ contain group functions. _________________________

The ____________________ function can be used to count the total records that meet a specific condition, including those that contain NULL values.

Which of the following is a correct statement?

The VARIANCE function can be used with ____ columns.

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

The $\underline { \text { TOTAL } }$ function is used to calculate the total value stored in a numeric field for a group of records. _________________________

The ____________________ function can be used to determine the number of rows that have non-NULL values in a specified column.

The ____________________ clause can be used to restrict rows, but not groups.

The GROUP BY clause can only be used when a SELECT statement includes a group function.

Results returned from a SELECT statement that include a GROUP BY clause will present the results in $\underline { \text { descending } }$ order of the column(s) listed in the GROUP BY clause. _________________________

Contents of the ORDERS table -Based on the contents of the ORDERS table, which of the following SELECT statements will determine the number of orders placed by each customer?

The ____ function can be used to determine the number of rows containing a specified value.

The ____ function is based upon the concept of a normal distribution.

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 optional UNIQUE keyword instructs Oracle 11g to include only unique numeric values in its calculation.

The WHERE clause can ‾\underline { \text { can } } can ​ contain group functions. _________________________

The ____________________ function can be used to count the total records that meet a specific condition, including those that contain NULL values.

Which of the following is a correct statement?

The VARIANCE function can be used with ____ columns.

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

The TOTAL ‾\underline { \text { TOTAL } } TOTAL ​ function is used to calculate the total value stored in a numeric field for a group of records. _________________________

The ____________________ function can be used to determine the number of rows that have non-NULL values in a specified column.

The ____________________ clause can be used to restrict rows, but not groups.

The GROUP BY clause can only be used when a SELECT statement includes a group function.

Results returned from a SELECT statement that include a GROUP BY clause will present the results in descending ‾\underline { \text { descending } } descending ​ order of the column(s) listed in the GROUP BY clause. _________________________

Contents of the ORDERS table -Based on the contents of the ORDERS table, which of the following SELECT statements will determine the number of orders placed by each customer?

The ____ function can be used to determine the number of rows containing a specified value.

The ____ function is based upon the concept of a normal distribution.

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 WHERE clause $\underline { \text { can } }$ contain group functions. _________________________

The $\underline { \text { TOTAL } }$ function is used to calculate the total value stored in a numeric field for a group of records. _________________________

Results returned from a SELECT statement that include a GROUP BY clause will present the results in $\underline { \text { descending } }$ order of the column(s) listed in the GROUP BY clause. _________________________