Exam 12: Subqueries and Merge Statements

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

A(n) ____________________ subquery returns more than one column to the outer query.

The results of the subquery are passed to the $\underline {\text { inner } }$ query. _________________________

In Oracle11g, there is no depth limit on the number of subqueries that can be nested in a(n) $\underline { \text { FROM } }$ clause. _________________________

The only type of subquery that can be used in a SELECT clause is a(n) ____________________ subquery.

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.

A(n) ____________________ subquery can return only one row of results to the outer query.

Which clause is used when the group results of a subquery need to be restricted, based on some condition?

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

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.

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

If it is possible for a subquery to return a NULL value to the outer query for comparison, the ____ function should be used to substitute an actual value for the NULL.

A(n) $\underline {\text { GROUP BY }}$ clause can be used in a subquery. _________________________

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

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

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

Single-row operators can be used with multiple-row subqueries that return only one column of results.

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

A subquery is a complete query nested inside another query.

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