Question 1

A subquery nested in a WHERE clause can only be on the $\underline {\text { left }}$side of the comparison operator. _________________________

Accepted Answer

A) True 
 B)False

Question 2

Valid multiple-row operators include ANY, ALL, and ____________________.

Accepted Answer

The answer of Valid multiple-row operators include ANY, ALL, and...

Question 3

Contents of the CUSTOMERS table
  
-Based upon the contents of the CUSTOMERS table, which of the following would be the most appropriate use of a subquery?

Accepted Answer

A)  When searching for all customers who live in the same state as customer# 1007. 
B)  When searching for all customers who were referred by customer# 1003. 
C)  When searching for all customers with the last name of Thompson. 
D)  When searching for all customers assigned customer# 1010. 
A)  When searching for all customers who live in the same state as customer# 1007. 
B)  When searching for all customers who were referred by customer# 1003. 
C)  When searching for all customers with the last name of Thompson. 
D)  When searching for all customers assigned customer# 1010.

Question 4

Which of the following operators is used with a multiple-row subquery?

Accepted Answer

A)  IN 
B)  ANY 
C)  ALL 
D)  all of the above 
A)  IN 
B)  ANY 
C)  ALL 
D)  all of the above

Question 5

The following SQL statement contains what type of subquery? SELECT b.title, b.retail, a.category, a.cataverage
FROM books b, (SELECT category, AVG(retail) cataverage
FROM books GROUP BY category) a

Accepted Answer

A)  single-row subquery 
B)  multiple-row subquery 
C)  inline view 
D)  none of the above 
A)  single-row subquery 
B)  multiple-row subquery 
C)  inline view 
D)  none of the above

Question 6

If a subquery references a column from the outer query, then it is a(n) ____________________ subquery.

Accepted Answer

The answer of If a subquery references a column from...

Question 7

If the value of the EXISTS operator is ____________________, then the rows meeting the condition are displayed.

Accepted Answer

The answer of If the value of the EXISTS operator...

Question 8

Contents of the BOOKS table
  
-Based upon the contents of the BOOKS table, which line of the following SQL statement contains an error? 1 SELECT title, pubid, cost, retail
2 FROM books
3 WHERE (pubid, cost)
4 (SELECT pubid, cost)
5 FROM books
6 WHERE pubid = 3);

Accepted Answer

A)  Line 1 
B)  Line 4 
C)  Line 5 
D)  Line 6 
A)  Line 1 
B)  Line 4 
C)  Line 5 
D)  Line 6

Question 9

Any type of subquery can be used in the FROM, WHERE, or ____________________ clause of a SELECT statement.

Accepted Answer

The answer of Any type of subquery can be used...

Question 10

A subquery is required when the condition for the outer query is based upon an unknown.

Accepted Answer

A) True 
 B)False

Question 11

A correlated subquery is one in which the inner query is executed first, and then the outer query is executed.

Accepted Answer

A) True 
 B)False

Question 12

Valid single-row operators include =, >, =, <=.

Accepted Answer

A) True 
 B)False

Question 13

The $\underline {\mathrm{< ANY} }$ operator indicates that a value must be less than the lowest value returned by the subquery to be included in the results. _________________________

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

A subquery, except one in the FROM clause, can't have an $\underline { \text { ORDER BY } }$ clause. _________________________

Accepted Answer

A) True 
 B)False

Question 16

If a multiple-column subquery is contained in the WHERE or HAVING clause of the outer query, the ____________________ operator must be used.

Accepted Answer

The answer of If a multiple-column subquery is contained in...

Question 17

The $\underline {\text { IN } }$ operator is valid for multiple-row subqueries. _________________________

Accepted Answer

A) True 
 B)False

Question 18

If a subquery is contained in a WHERE or HAVING clause, the subquery must be on the ____________________ side of the comparison operator.

Accepted Answer

The answer of If a subquery is contained in a...

Question 19

A temporary table that is created when a multiple-column subquery is used in the FROM clause of an outer query is called a(n) ____.

Accepted Answer

A)  inner view 
B)  outer view 
C)  inline view 
D)  natural view 
A)  inner view 
B)  outer view 
C)  inline view 
D)  natural view

Question 20

A(n) $\underline {\text { outer } }$ query is also referred to as a parent query. _________________________

Accepted Answer

A) True 
 B)False

A subquery nested in a WHERE clause can only be on the $\underline {\text { left }}$ side of the comparison operator. _________________________

Valid multiple-row operators include ANY, ALL, and ____________________.

Contents of the CUSTOMERS table -Based upon the contents of the CUSTOMERS table, which of the following would be the most appropriate use of a subquery?

Which of the following operators is used with a multiple-row subquery?

The following SQL statement contains what type of subquery? SELECT b.title, b.retail, a.category, a.cataverage FROM books b, (SELECT category, AVG(retail) cataverage FROM books GROUP BY category) a

If a subquery references a column from the outer query, then it is a(n) ____________________ subquery.

If the value of the EXISTS operator is ____________________, then the rows meeting the condition are displayed.

Contents of the BOOKS table -Based upon the contents of the BOOKS table, which line of the following SQL statement contains an error? 1 SELECT title, pubid, cost, retail 2 FROM books 3 WHERE (pubid, cost) 4 (SELECT pubid, cost) 5 FROM books 6 WHERE pubid = 3);

Any type of subquery can be used in the FROM, WHERE, or ____________________ clause of a SELECT statement.

A subquery is required when the condition for the outer query is based upon an unknown.

A correlated subquery is one in which the inner query is executed first, and then the outer query is executed.

Valid single-row operators include =, >, <, >=, <=.

The $\underline {\mathrm{< ANY} }$ operator indicates that a value must be less than the lowest value returned by the subquery to be included in the results. _________________________

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

A subquery, except one in the FROM clause, can't have an $\underline { \text { ORDER BY } }$ clause. _________________________

If a multiple-column subquery is contained in the WHERE or HAVING clause of the outer query, the ____________________ operator must be used.

The $\underline {\text { IN } }$ operator is valid for multiple-row subqueries. _________________________

If a subquery is contained in a WHERE or HAVING clause, the subquery must be on the ____________________ side of the comparison operator.

A temporary table that is created when a multiple-column subquery is used in the FROM clause of an outer query is called a(n) ____.

A(n) $\underline {\text { outer } }$ query is also referred to as a parent query. _________________________

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

A subquery nested in a WHERE clause can only be on the left ‾\underline {\text { left }} left ​ side of the comparison operator. _________________________

Valid multiple-row operators include ANY, ALL, and ____________________.

Contents of the CUSTOMERS table -Based upon the contents of the CUSTOMERS table, which of the following would be the most appropriate use of a subquery?

Which of the following operators is used with a multiple-row subquery?

The following SQL statement contains what type of subquery? SELECT b.title, b.retail, a.category, a.cataverage FROM books b, (SELECT category, AVG(retail) cataverage FROM books GROUP BY category) a

If a subquery references a column from the outer query, then it is a(n) ____________________ subquery.

If the value of the EXISTS operator is ____________________, then the rows meeting the condition are displayed.

Contents of the BOOKS table -Based upon the contents of the BOOKS table, which line of the following SQL statement contains an error? 1 SELECT title, pubid, cost, retail 2 FROM books 3 WHERE (pubid, cost) 4 (SELECT pubid, cost) 5 FROM books 6 WHERE pubid = 3);

Any type of subquery can be used in the FROM, WHERE, or ____________________ clause of a SELECT statement.

A subquery is required when the condition for the outer query is based upon an unknown.

A correlated subquery is one in which the inner query is executed first, and then the outer query is executed.

Valid single-row operators include =, >, <, >=, <=.

The <ANY‾\underline {\mathrm{< ANY} }<ANY​ operator indicates that a value must be less than the lowest value returned by the subquery to be included in the results. _________________________

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

A subquery, except one in the FROM clause, can't have an ORDER BY ‾\underline { \text { ORDER BY } } ORDER BY ​ clause. _________________________

If a multiple-column subquery is contained in the WHERE or HAVING clause of the outer query, the ____________________ operator must be used.

The IN ‾\underline {\text { IN } } IN ​ operator is valid for multiple-row subqueries. _________________________

If a subquery is contained in a WHERE or HAVING clause, the subquery must be on the ____________________ side of the comparison operator.

A temporary table that is created when a multiple-column subquery is used in the FROM clause of an outer query is called a(n) ____.

A(n) outer ‾\underline {\text { outer } } outer ​ query is also referred to as a parent query. _________________________

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

A subquery nested in a WHERE clause can only be on the $\underline {\text { left }}$ side of the comparison operator. _________________________

The $\underline {\mathrm{< ANY} }$ operator indicates that a value must be less than the lowest value returned by the subquery to be included in the results. _________________________

A subquery, except one in the FROM clause, can't have an $\underline { \text { ORDER BY } }$ clause. _________________________

The $\underline {\text { IN } }$ operator is valid for multiple-row subqueries. _________________________

A(n) $\underline {\text { outer } }$ query is also referred to as a parent query. _________________________