Question 1

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

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

Accepted Answer

A) True 
 B)False

Question 3

When the SELECT statement includes both WHERE and GROUP BY clauses,the GROUP BY clause is always evaluated first.​

Accepted Answer

A) True 
 B)False

Question 4

The AVG function only includes non-NULL values in its calculations._________________________​

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

*
asterisk

Question 7

The GROUP BY clause is used to restrict the groups returned by a query._________________________​

Accepted Answer

A) True 
 B)False

Question 8

Contents of the ORDERS table​
  
-​Based on the contents of the ORDERS table,which of the following SQL statements will display the number of orders that have not been shipped?

Accepted Answer

A)  SELECT order#,COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL; 
B)  ​SELECT order#,COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL
GROUP BY order#; 
C)  ​SELECT COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL; 
D)  ​SELECT COUNT(*)
FROM orders
WHERE shipdate IS NULL; 
A)  SELECT order#,COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL; 
B)  ​SELECT order#,COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL
GROUP BY order#; 
C)  ​SELECT COUNT(shipdate)
FROM orders
WHERE shipdate IS NULL; 
D)  ​SELECT COUNT(*)
FROM orders
WHERE shipdate IS NULL;

Question 9

Pattern matching features available in a SELECT are targeted to analyze patterns or trends of a specific column of data across many rows.​

Accepted Answer

A) True 
 B)False

Question 10

The STDDEV function calculates the standard deviation for the data contained in a specified field._________________________​

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

The ____ function is used to calculate the total amount stored in a numeric field.​

Accepted Answer

A)  ​TOTAL 
B)  ​SUM 
C)  ​AVERAGE 
D)  ​ADD 
A)  ​TOTAL 
B)  ​SUM 
C)  ​AVERAGE 
D)  ​ADD

Question 14

Which of the following is a valid SQL statement?​

Accepted Answer

A)  ​SELECT SUM(quantity*retail)"Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
WHERE orderdate = '02-APR-03'; 
B)  ​SELECT SUM(quantity*retail)"Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'; 
C)  ​SELECT customer#,SUM(quantity*retail)"Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'; 
D)  SELECT customer#,SUM(quantity*retail)"Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'
GROUP BY customer#;​ 
A)  ​SELECT SUM(quantity*retail)"Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
WHERE orderdate = '02-APR-03'; 
B)  ​SELECT SUM(quantity*retail)"Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'; 
C)  ​SELECT customer#,SUM(quantity*retail)"Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'; 
D)  SELECT customer#,SUM(quantity*retail)"Total Sales"
FROM orders JOIN orderitems ON orders.order# = orderitems.order#
JOIN books ON orderitems ON orderitems.ISBN = books.ISBN
HAVING orderdate = '02-APR-03'
GROUP BY customer#;​

Question 15

​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 16

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 17

​By default,the AVG function assumes the ____________________ keyword,which indicates that all values should be included in the calculation.

Accepted Answer

The answer of ​By default,the AVG function assumes the ____________________...

Question 18

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 19

​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,the...

Question 20

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

Accepted Answer

A) True 
 B)False

The TOTAL function is used to calculate the total value stored in a numeric field for a group of records._________________________

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

When the SELECT statement includes both WHERE and GROUP BY clauses,the GROUP BY clause is always evaluated first.

The AVG function only includes non-NULL values in its calculations._________________________

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

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

The GROUP BY clause is used to restrict the groups returned by a query._________________________

Contents of the ORDERS table -Based on the contents of the ORDERS table,which of the following SQL statements will display the number of orders that have not been shipped?

Pattern matching features available in a SELECT are targeted to analyze patterns or trends of a specific column of data across many rows.

The STDDEV function calculates the standard deviation for the data contained in a specified field._________________________

The MIN function can be used with ____ columns.

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

The ____ function is used to calculate the total amount stored in a numeric field.

Which of the following is a valid SQL statement?

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

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

By default,the AVG function assumes the ____________________ keyword,which indicates that all values should be included in the calculation.

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

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

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

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 TOTAL function is used to calculate the total value stored in a numeric field for a group of records._________________________​

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

When the SELECT statement includes both WHERE and GROUP BY clauses,the GROUP BY clause is always evaluated first.​

The AVG function only includes non-NULL values in its calculations._________________________​

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

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

The GROUP BY clause is used to restrict the groups returned by a query._________________________​

Contents of the ORDERS table​ -​Based on the contents of the ORDERS table,which of the following SQL statements will display the number of orders that have not been shipped?

Pattern matching features available in a SELECT are targeted to analyze patterns or trends of a specific column of data across many rows.​

The STDDEV function calculates the standard deviation for the data contained in a specified field._________________________​

The MIN function can be used with ____ columns.​

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

The ____ function is used to calculate the total amount stored in a numeric field.​

Which of the following is a valid SQL statement?​

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

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

​By default,the AVG function assumes the ____________________ keyword,which indicates that all values should be included in the calculation.

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

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

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

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 TOTAL function is used to calculate the total value stored in a numeric field for a group of records._________________________

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

When the SELECT statement includes both WHERE and GROUP BY clauses,the GROUP BY clause is always evaluated first.

The AVG function only includes non-NULL values in its calculations._________________________

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

The GROUP BY clause is used to restrict the groups returned by a query._________________________

Contents of the ORDERS table -Based on the contents of the ORDERS table,which of the following SQL statements will display the number of orders that have not been shipped?

Pattern matching features available in a SELECT are targeted to analyze patterns or trends of a specific column of data across many rows.

The STDDEV function calculates the standard deviation for the data contained in a specified field._________________________

The MIN function can be used with ____ columns.

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

The ____ function is used to calculate the total amount stored in a numeric field.

Which of the following is a valid SQL statement?

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

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

By default,the AVG function assumes the ____________________ keyword,which indicates that all values should be included in the calculation.

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

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

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