SQL Writing Subqueries 2

Question 1

Which keyword tests whether a subquery returns any rows at all?

Accepted Answer

EXISTS

Answer

INCLUDES

Answer

CONTAINS

Answer

HASROWS

Question 2

A subquery that references a column from the outer query is called what?

Accepted Answer

Correlated subquery

Answer

Scalar subquery

Answer

Derived table

Answer

Nested join

Question 3

What does a scalar subquery return?

Accepted Answer

A single value

Answer

Multiple columns

Answer

An entire table

Answer

A boolean only

Question 4

Which operator lets a value match ANY result from a subquery returning multiple rows?

Accepted Answer

IN

Answer

BETWEEN

Answer

LIKE

Answer

IS

Question 5

Where can a subquery used as a derived table appear?

Accepted Answer

In the FROM clause

Answer

Only in WHERE

Answer

Only in GROUP BY

Answer

Only in ORDER BY

Question 6

What is required when a subquery is compared with = (equals)?

Accepted Answer

It must return a single value

Answer

It must return multiple rows

Answer

It must use EXISTS

Answer

It must be correlated

Question 7

Which clause CANNOT typically contain a subquery in standard SQL?

Accepted Answer

The keyword list of an INDEX definition

Answer

WHERE

Answer

FROM

Answer

SELECT