Question 1

A subquery,except one in the FROM clause,can't have an ORDER BY clause._________________________​

Accepted Answer

A) True 
 B)False

Question 2

The ____________________ operator indicates that a value must be less than the highest value returned by a subquery.​

Accepted Answer

The answer of The ____________________ operator indicates that a value...

Question 3

The results of the subquery are passed to the inner query._________________________

Accepted Answer

A) True 
 B)False

Question 4

A subquery is a(n)____________________ query - one complete query inside another query

Accepted Answer

The answer of A subquery is a(n)____________________ query - one...

Question 5

An outer query is also referred to as a(n)____ query.​

Accepted Answer

A)  ​parent query 
B)  ​outer view 
C)  ​outline view 
D)  ​all of the above 
A)  ​parent query 
B)  ​outer view 
C)  ​outline view 
D)  ​all of the above

Question 6

​With a(n)____________________ subquery,the subquery is executed once for each row in the outer query.

Accepted Answer

The answer of ​With a(n)____________________ subquery,the subquery is executed once...

Question 7

A subquery is required when the condition for the inner query is based upon an unknown._________________________​

Accepted Answer

A) True 
 B)False

Question 8

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 9

With a(n)____________________ subquery,the inner query is executed first and the results are passed back to the outer query.

Accepted Answer

The answer of With a(n)____________________ subquery,the inner query is executed...

Question 10

A(n)GROUP BY clause can be used in a subquery._________________________​

Accepted Answer

A) True 
 B)False

Question 11

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 12

​The ____ operator is used to determine whether a condition is present in a subquery.

Accepted Answer

A)  ​IN 
B)  ​ALL 
C)  ​ANY 
D)  ​EXISTS 
A)  ​IN 
B)  ​ALL 
C)  ​ANY 
D)  ​EXISTS

Question 13

A correlated subquery references one or more columns in the outer query,and the EXISTS operator is used to test whether the relationship or link is present.​

Accepted Answer

A) True 
 B)False

Question 14

​The following SQL statement contains what type of subqueries?
SELECT isbn,title FROM books WHERE pubid =
(SELECT pubid FROM books WHERE title = 'SHORTEST POEMS')
AND retail-cost >
(SELECT AVG(retail-cost)FROM books);

Accepted Answer

A)  ​single-row 
B)  ​multiple-row 
C)  ​multiple-column 
D)  ​inline view 
A)  ​single-row 
B)  ​multiple-row 
C)  ​multiple-column 
D)  ​inline view

Question 15

The <ALL operator indicates that a value must be ____ value returned by the subquery.​

Accepted Answer

A)  ​more than the highest 
B)  ​less than the highest 
C)  ​more than the lowest 
D)  ​less than the lowest 
A)  ​more than the highest 
B)  ​less than the highest 
C)  ​more than the lowest 
D)  ​less than the lowest

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

​With uncorrelated subqueries,the inner

Question 18

Multiple-row subqueries are nested queries that can return more than one row of results to the parent query.​

Accepted Answer

A) True 
 B)False

Question 19

The <ALL operator indicates that for a value to be included in the results,it must be less than the lowest value returned by the subquery.​

Accepted Answer

A) True 
 B)False

Question 20

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

A subquery,except one in the FROM clause,can't have an ORDER BY clause._________________________

The ____________________ operator indicates that a value must be less than the highest value returned by a subquery.

The results of the subquery are passed to the inner query._________________________

A subquery is a(n)____________________ query - one complete query inside another query

An outer query is also referred to as a(n)____ query.

With a(n)____________________ subquery,the subquery is executed once for each row in the outer query.

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

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)____.

With a(n)____________________ subquery,the inner query is executed first and the results are passed back to the outer query.

A(n)GROUP BY clause can be used in a subquery._________________________

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

The ____ operator is used to determine whether a condition is present in a subquery.

A correlated subquery references one or more columns in the outer query,and the EXISTS operator is used to test whether the relationship or link is present.

The following SQL statement contains what type of subqueries? SELECT isbn,title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS') AND retail-cost > (SELECT AVG(retail-cost)FROM books);

The <ALL operator indicates that a value must be ____ value returned by the subquery.

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

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

Multiple-row subqueries are nested queries that can return more than one row of results to the parent query.

The <ALL operator indicates that for a value to be included in the results,it must be less than the lowest value returned by the subquery.

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

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,except one in the FROM clause,can't have an ORDER BY clause._________________________​

The ____________________ operator indicates that a value must be less than the highest value returned by a subquery.​

The results of the subquery are passed to the inner query._________________________

A subquery is a(n)____________________ query - one complete query inside another query

An outer query is also referred to as a(n)____ query.​

​With a(n)____________________ subquery,the subquery is executed once for each row in the outer query.

A subquery is required when the condition for the inner query is based upon an unknown._________________________​

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)____.​

With a(n)____________________ subquery,the inner query is executed first and the results are passed back to the outer query.

A(n)GROUP BY clause can be used in a subquery._________________________​

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

​The ____ operator is used to determine whether a condition is present in a subquery.

A correlated subquery references one or more columns in the outer query,and the EXISTS operator is used to test whether the relationship or link is present.​

​The following SQL statement contains what type of subqueries? SELECT isbn,title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS') AND retail-cost > (SELECT AVG(retail-cost)FROM books);

The <ALL operator indicates that a value must be ____ value returned by the subquery.​

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

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

Multiple-row subqueries are nested queries that can return more than one row of results to the parent query.​

The <ALL operator indicates that for a value to be included in the results,it must be less than the lowest value returned by the subquery.​

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

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,except one in the FROM clause,can't have an ORDER BY clause._________________________

The ____________________ operator indicates that a value must be less than the highest value returned by a subquery.

An outer query is also referred to as a(n)____ query.

With a(n)____________________ subquery,the subquery is executed once for each row in the outer query.

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

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)GROUP BY clause can be used in a subquery._________________________

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

The ____ operator is used to determine whether a condition is present in a subquery.

A correlated subquery references one or more columns in the outer query,and the EXISTS operator is used to test whether the relationship or link is present.

The following SQL statement contains what type of subqueries? SELECT isbn,title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS') AND retail-cost > (SELECT AVG(retail-cost)FROM books);

The <ALL operator indicates that a value must be ____ value returned by the subquery.

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

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

Multiple-row subqueries are nested queries that can return more than one row of results to the parent query.

The <ALL operator indicates that for a value to be included in the results,it must be less than the lowest value returned by the subquery.

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