Week 13

Question 1

Returns to the outer query one row of results consisting of one column only.

A. Correlated subquery
B. multiple-row subquery
C. single-row subquery
D. multiple-column subquery

Answer 1

C. single-row subquery

Question 2

What operator is used when you need to compare against individual data?

Answer 2

WHERE

Question 3

What operator is used when the returned value is compared to grouped data?

Answer 3

HAVING

Question 4

Which of the following is NOT used in a multiple-row subquery?

A. Any
B. All
C. In
D. =

Answer 4

D. =

Question 5

A ____ subquery references one or more columns in the outer query and tests whether the relationship or link is present.

Answer 5

correlated

Question 6

The ____operator is used in a correlated subquery.

Answer 6

EXISTS

Question 7

T/F: A MERGE statement takes one table and merges it into another table and must include what to do when the data is present and when it is not present.

Answer 7

True

Use WHEN MATCHED THEN
and a WHEN NOT MATCHED THEN statements

Question 8

A subquery must contain at a minimum what two operators?

Answer 8

SELECT and FROM

Question 9

T/F:

IN is not a valid operator for a multiple-column subquery.

Answer 9

False

Question 10

T/F: A subquery nested in a SELECT clause cannot contain an ORDER BY clause.

Answer 10

True

Question 11

T/F:

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

Answer 11

False

Question 12

A complete query nested inside another query is called a(n) ____.

Answer 12

subquery