Exam 12: Subqueries and Merge Statements

Contents of the CUSTOMERS table -Based on the contents of the CUSTOMERS table, which SQL statement will display the customers residing in the same state as customer#1013?

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

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

Explain the difference between multiple-row and multiple-column subqueries.

In Oracle11g, a MERGE statement compares data between two tables and can perform a series of DML actions to assist in synchronizing the data of the two tables.

The EXISTS operator must be listed ____.

In Oracle11g, subqueries can be nested to a depth of 255 in a WHERE clause.

A(n) ____________________ query can return several rows of results, but only one column.

A(n) $\underline {\text { correlated }}$ subquery is when the outer query is executed first, and then the inner query is executed. _________________________

When used with a multiple-row subquery, the IN operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

A subquery must be enclosed in a set of ____________________.

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

A(n) single-row subquery can be nested in a(n) $\underline {\text { SELECT } }$ clause. _________________________

The results of the outer query are passed to the inner query.

The operators =, <, >, <=, >=, and <> are referred to as ____ operators.

Which of the following can be used in a WHERE clause?

With a MERGE statement, a series of ____ actions can occur with a single SQL statement.

You $\underline {\text { can } }$ include multiple subqueries in a SELECT statement. _________________________

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

A subquery, except one in the FROM clause, cannot contain a(n) ____________________ clause.