Question 1

The <= operator is referred to as a(n) ____ operator.

Accepted Answer

A)  multiple-row 
B)  correlated 
C)  uncorrelated 
D)  single-row 
A)  multiple-row 
B)  correlated 
C)  uncorrelated 
D)  single-row

Question 2

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

Accepted Answer

A) IN B) >ANY C) ALL A) IN B) >ANY C) ALL

Question 3

The greater than operator, >, is a valid operator for $\underline { \text { multiple-row } }$ subqueries. _________________________

Accepted Answer

A) True 
 B)False

Question 4

Which of the following terms refers to a type of subquery that is processed, or executed, once for each row in the outer query?

Accepted Answer

A)  correlated subquery 
B)  uncorrelated subquery 
C)  multiple-column subquery 
D)  single-row subquery 
A)  correlated subquery 
B)  uncorrelated subquery 
C)  multiple-column subquery 
D)  single-row subquery

Question 5

Contents of the CUSTOMERS table
  
-Based on the contents of the CUSTOMERS table, which of the following SQL statements will display the customer# of all customers who were referred by the same individual that referred customer# 1003?

Accepted Answer

A)  SELECT customer# FROM customers WHERE referred =
(SELECT referred FROM customers WHERE customer# = 1003); 
B)  SELECT customer# FROM customers WHERE referred EXISTS
(SELECT referred FROM customers WHERE customer# = 1003); 
C)  SELECT customer# FROM customers WHERE NVL(referred, 0) =
(SELECT NVL(referred,0) FROM customers WHERE customer# = 1003); 
D)  SELECT customer# FROM customers WHERE NVL(referred,0) =
(SELECT referred FROM customers WHERE customer# = 1003); 
A)  SELECT customer# FROM customers WHERE referred =
(SELECT referred FROM customers WHERE customer# = 1003); 
B)  SELECT customer# FROM customers WHERE referred EXISTS
(SELECT referred FROM customers WHERE customer# = 1003); 
C)  SELECT customer# FROM customers WHERE NVL(referred, 0) =
(SELECT NVL(referred,0) FROM customers WHERE customer# = 1003); 
D)  SELECT customer# FROM customers WHERE NVL(referred,0) =
(SELECT referred FROM customers WHERE customer# = 1003);

Question 6

The following SQL statement contains which type of subquery? SELECT title, retail, category, cataverage FROM books NATURAL JOIN
(SELECT category, AVG(retail) cataverage FROM books GROUP BY category);

Accepted Answer

A)  single-row 
B)  multiple-row 
C)  correlated 
D)  uncorrelated 
A)  single-row 
B)  multiple-row 
C)  correlated 
D)  uncorrelated

Question 7

A multiple-row subquery can be nested in a HAVING clause.

Accepted Answer

A) True 
 B)False

Question 8

Explain the different processing methods used by correlated and uncorrelated subqueries.

Accepted Answer

With uncorrelated subqueries, the inner

Question 9

A group function can be used in a(n) $\underline {\text { inline view }}$. _________________________

Accepted Answer

A) True 
 B)False

Question 10

When a multiple-column subquery is included in the WHERE or HAVING clause of the outer query, which operator is used by the outer query to evaluate the results of the subquery?

Accepted Answer

A)  > 
B)  BETWEEN 
C)  IN 
D)  none of the above 
A)  > 
B)  BETWEEN 
C)  IN 
D)  none of the above

Question 11

A subquery is required when the condition for the $\underline {\text { inner } }$query is based upon an unknown. _________________________

Accepted Answer

A) True 
 B)False

Question 12

If a subquery is nested in a HAVING clause, the subquery must be on the right side of the comparison operator.

Accepted Answer

A) True 
 B)False

Question 13

The EXISTS operator can be used with multiple-row subqueries.

Accepted Answer

A) True 
 B)False

Question 14

Any type of subquery can be used in the ____ clause of a SELECT statement.

Accepted Answer

A)  WHERE 
B)  HAVING 
C)  FROM 
D)  all of the above 
A)  WHERE 
B)  HAVING 
C)  FROM 
D)  all of the above

Question 15

The results of a subquery are passed back to the ____________________ query.

Accepted Answer

The answer of The results of a subquery are passed...

Question 16

Contents of the BOOKS table
  
-Based on the contents of the BOOKS table, which of the following SQL statements will return an error message?

Accepted Answer

A)  SELECT title FROM books WHERE retail =
(SELECT MAX(retail) FROM books); 
B)  SELECT title FROM books WHERE retail IN
(SELECT MAX(retail) FROM books); 
C)  SELECT title FROM books WHERE retail >
(SELECT MAX(retail) FROM books); 
D)  none of the above 
A)  SELECT title FROM books WHERE retail =
(SELECT MAX(retail) FROM books); 
B)  SELECT title FROM books WHERE retail IN
(SELECT MAX(retail) FROM books); 
C)  SELECT title FROM books WHERE retail >
(SELECT MAX(retail) FROM books); 
D)  none of the above

Question 17

A multiple-column subquery cannot be nested in a WHERE clause.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following operators is the equivalent of the IN comparison operator?

Accepted Answer

A) ANY C) =ANY D) =ALL A) ANY C) =ANY D) =ALL

Question 19

With a(n) ____________________ statement, a series of DML actions can occur with a single SQL statement.

Accepted Answer

The answer of With a(n) ____________________ statement, a series of...

Question 20

The $\underline{=\mathrm{ANY}}$ operator yields the same results as using the IN multiple-row operator. _________________________

Accepted Answer

A) True 
 B)False

The <= operator is referred to as a(n) ____ operator.

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

The greater than operator, >, is a valid operator for $\underline { \text { multiple-row } }$ subqueries. _________________________

Which of the following terms refers to a type of subquery that is processed, or executed, once for each row in the outer query?

Contents of the CUSTOMERS table -Based on the contents of the CUSTOMERS table, which of the following SQL statements will display the customer# of all customers who were referred by the same individual that referred customer# 1003?

The following SQL statement contains which type of subquery? SELECT title, retail, category, cataverage FROM books NATURAL JOIN (SELECT category, AVG(retail) cataverage FROM books GROUP BY category);

A multiple-row subquery can be nested in a HAVING clause.

Explain the different processing methods used by correlated and uncorrelated subqueries.

A group function can be used in a(n) $\underline {\text { inline view }}$ . _________________________

When a multiple-column subquery is included in the WHERE or HAVING clause of the outer query, which operator is used by the outer query to evaluate the results of the subquery?

A subquery is required when the condition for the $\underline {\text { inner } }$ query is based upon an unknown. _________________________

If a subquery is nested in a HAVING clause, the subquery must be on the right side of the comparison operator.

The EXISTS operator can be used with multiple-row subqueries.

Any type of subquery can be used in the ____ clause of a SELECT statement.

The results of a subquery are passed back to the ____________________ query.

Contents of the BOOKS table -Based on the contents of the BOOKS table, which of the following SQL statements will return an error message?

A multiple-column subquery cannot be nested in a WHERE clause.

Which of the following operators is the equivalent of the IN comparison operator?

With a(n) ____________________ statement, a series of DML actions can occur with a single SQL statement.

The $\underline{=\mathrm{ANY}}$ operator yields the same results as using the IN multiple-row operator. _________________________

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

Group Functions

Views

Filters

Exam 12: Subqueries and Merge Statements

The <= operator is referred to as a(n) ____ operator.

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

The greater than operator, >, is a valid operator for multiple-row ‾\underline { \text { multiple-row } } multiple-row ​ subqueries. _________________________

Which of the following terms refers to a type of subquery that is processed, or executed, once for each row in the outer query?

Contents of the CUSTOMERS table -Based on the contents of the CUSTOMERS table, which of the following SQL statements will display the customer# of all customers who were referred by the same individual that referred customer# 1003?

The following SQL statement contains which type of subquery? SELECT title, retail, category, cataverage FROM books NATURAL JOIN (SELECT category, AVG(retail) cataverage FROM books GROUP BY category);

A multiple-row subquery can be nested in a HAVING clause.

Explain the different processing methods used by correlated and uncorrelated subqueries.

A group function can be used in a(n) inline view ‾\underline {\text { inline view }} inline view ​ . _________________________

When a multiple-column subquery is included in the WHERE or HAVING clause of the outer query, which operator is used by the outer query to evaluate the results of the subquery?

A subquery is required when the condition for the inner ‾\underline {\text { inner } } inner ​ query is based upon an unknown. _________________________

If a subquery is nested in a HAVING clause, the subquery must be on the right side of the comparison operator.

The EXISTS operator can be used with multiple-row subqueries.

Any type of subquery can be used in the ____ clause of a SELECT statement.

The results of a subquery are passed back to the ____________________ query.

Contents of the BOOKS table -Based on the contents of the BOOKS table, which of the following SQL statements will return an error message?

A multiple-column subquery cannot be nested in a WHERE clause.

Which of the following operators is the equivalent of the IN comparison operator?

With a(n) ____________________ statement, a series of DML actions can occur with a single SQL statement.

The =ANY‾\underline{=\mathrm{ANY}}=ANY​ operator yields the same results as using the IN multiple-row operator. _________________________

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

Group Functions

Views

Filters

The greater than operator, >, is a valid operator for $\underline { \text { multiple-row } }$ subqueries. _________________________

A group function can be used in a(n) $\underline {\text { inline view }}$ . _________________________

A subquery is required when the condition for the $\underline {\text { inner } }$ query is based upon an unknown. _________________________

The $\underline{=\mathrm{ANY}}$ operator yields the same results as using the IN multiple-row operator. _________________________