Question 1

When the subquery is executed first and the value is passed back as input to the outer query,the subquery is known as an uncorrelated subquery.​

Accepted Answer

A) True 
 B)False

Question 2

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

If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.​

Accepted Answer

A)  ​GROUP BY 
B)  ​WHERE 
C)  ​HAVING 
D)  ​FROM 
A)  ​GROUP BY 
B)  ​WHERE 
C)  ​HAVING 
D)  ​FROM

Question 4

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 5

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 6

Which of the following can be used in a WHERE clause?​

Accepted Answer

A)  ​single-row subquery 
B)  ​multiple-column subquery 
C)  ​multiple-row subquery 
D)  ​all of the above 
A)  ​single-row subquery 
B)  ​multiple-column subquery 
C)  ​multiple-row subquery 
D)  ​all of the above

Question 7

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 8

A subquery nested in a WHERE clause can only be on the left side of the comparison operator._________________________​

Accepted Answer

A) True 
 B)False

Question 9

​A(n)____________________ query can return several rows of results,but only one column.

Accepted Answer

​multiple-

Question 10

When a multiple-column subquery is included in the outer query's WHERE clause,the column names listed in the WHERE clause must be in the same order as they're listed in the subquery's SELECT clause.​

Accepted Answer

A) True 
 B)False

Question 11

In Oracle12c,there is no depth limit on the number of subqueries that can be nested in a(n)FROM clause._________________________​

Accepted Answer

A) True 
 B)False

Question 12

The IN operator is valid for multiple-row subqueries._________________________​

Accepted Answer

A) True 
 B)False

Question 13

A subquery must include a(n)____ clause.​

Accepted Answer

A)  ​SELECT 
B)  ​FROM 
C)  ​WHERE 
D)  ​both a and b 
A)  ​SELECT 
B)  ​FROM 
C)  ​WHERE 
D)  ​both a and b

Question 14

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

When a multiple-column subquery is used in the outer query's FROM clause,it creates a temporary table,called an inline view,that can be referenced by other clauses of the outer query.​

Accepted Answer

A) True 
 B)False

Question 16

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

​A(n)____________________ subquery is a nested query that returns more than one row of results.

Accepted Answer

​multiple-

Question 18

A correlated subquery is a subquery that is executed once for each row in the outer query.​

Accepted Answer

A) True 
 B)False

Question 19

Contents of the CUSTOMERS table​
  
-​Based on the contents of the CUSTOMERS table,which SQL statement will display the customers residing in the same state as customer#1013?

Accepted Answer

A)  ​SELECT customer# FROM customers WHERE customer# =
(SELECT state FROM customers WHERE state = 'NJ'); 
B)  ​SELECT customer# FROM customers WHERE state =
(SELECT state FROM customers WHERE customer#=1013); 
C)  ​SELECT customer# FROM customers WHERE customer# IN
(SELECT state FROM customers WHERE state = 'NJ'); 
D)  ​SELECT customer# FROM customers WHERE state EXISTS
(SELECT state FROM customers WHERE customer#=1013); 
A)  ​SELECT customer# FROM customers WHERE customer# =
(SELECT state FROM customers WHERE state = 'NJ'); 
B)  ​SELECT customer# FROM customers WHERE state =
(SELECT state FROM customers WHERE customer#=1013); 
C)  ​SELECT customer# FROM customers WHERE customer# IN
(SELECT state FROM customers WHERE state = 'NJ'); 
D)  ​SELECT customer# FROM customers WHERE state EXISTS
(SELECT state FROM customers WHERE customer#=1013);

Question 20

When a multiple-column subquery is used in the WHERE clause of the outer query,the column names listed on the left side of the comparison operator must be enclosed in single-quotation marks._________________________​

Accepted Answer

A) True 
 B)False

When the subquery is executed first and the value is passed back as input to the outer query,the subquery is known as an uncorrelated subquery.

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

If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.

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

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?

Which of the following can be used in a WHERE clause?

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?

A subquery nested in a WHERE clause can only be on the left side of the comparison operator._________________________

A(n)____________________ query can return several rows of results,but only one column.

When a multiple-column subquery is included in the outer query's WHERE clause,the column names listed in the WHERE clause must be in the same order as they're listed in the subquery's SELECT clause.

In Oracle12c,there is no depth limit on the number of subqueries that can be nested in a(n)FROM clause._________________________

The IN operator is valid for multiple-row subqueries._________________________

A subquery must include a(n)____ clause.

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);

When a multiple-column subquery is used in the outer query's FROM clause,it creates a temporary table,called an inline view,that can be referenced by other clauses of the outer query.

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

A(n)____________________ subquery is a nested query that returns more than one row of results.

A correlated subquery is a subquery that is executed once for each row in the outer query.

Contents of the CUSTOMERS table -Based on the contents of the CUSTOMERS table,which SQL statement will display the customers residing in the same state as customer#1013?

When a multiple-column subquery is used in the WHERE clause of the outer query,the column names listed on the left side of the comparison operator must be enclosed in single-quotation marks._________________________

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

When the subquery is executed first and the value is passed back as input to the outer query,the subquery is known as an uncorrelated subquery.​

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

If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.​

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

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

Which of the following can be used in a WHERE clause?​

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?

A subquery nested in a WHERE clause can only be on the left side of the comparison operator._________________________​

​A(n)____________________ query can return several rows of results,but only one column.

When a multiple-column subquery is included in the outer query's WHERE clause,the column names listed in the WHERE clause must be in the same order as they're listed in the subquery's SELECT clause.​

In Oracle12c,there is no depth limit on the number of subqueries that can be nested in a(n)FROM clause._________________________​

The IN operator is valid for multiple-row subqueries._________________________​

A subquery must include a(n)____ clause.​

​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);

When a multiple-column subquery is used in the outer query's FROM clause,it creates a temporary table,called an inline view,that can be referenced by other clauses of the outer query.​

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

​A(n)____________________ subquery is a nested query that returns more than one row of results.

A correlated subquery is a subquery that is executed once for each row in the outer query.​

Contents of the CUSTOMERS table​ -​Based on the contents of the CUSTOMERS table,which SQL statement will display the customers residing in the same state as customer#1013?

When a multiple-column subquery is used in the WHERE clause of the outer query,the column names listed on the left side of the comparison operator must be enclosed in single-quotation marks._________________________​

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

When the subquery is executed first and the value is passed back as input to the outer query,the subquery is known as an uncorrelated subquery.

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

If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.

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

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?

Which of the following can be used in a WHERE clause?

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?

A subquery nested in a WHERE clause can only be on the left side of the comparison operator._________________________

A(n)____________________ query can return several rows of results,but only one column.

When a multiple-column subquery is included in the outer query's WHERE clause,the column names listed in the WHERE clause must be in the same order as they're listed in the subquery's SELECT clause.

In Oracle12c,there is no depth limit on the number of subqueries that can be nested in a(n)FROM clause._________________________

The IN operator is valid for multiple-row subqueries._________________________

A subquery must include a(n)____ clause.

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);

When a multiple-column subquery is used in the outer query's FROM clause,it creates a temporary table,called an inline view,that can be referenced by other clauses of the outer query.

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

A(n)____________________ subquery is a nested query that returns more than one row of results.

A correlated subquery is a subquery that is executed once for each row in the outer query.

Contents of the CUSTOMERS table -Based on the contents of the CUSTOMERS table,which SQL statement will display the customers residing in the same state as customer#1013?

When a multiple-column subquery is used in the WHERE clause of the outer query,the column names listed on the left side of the comparison operator must be enclosed in single-quotation marks._________________________