Exam 12: Subqueries and Merge Statements

Which operator will instruct Oracle10g to list all records with a value that is less than the highest value returned by the subquery?

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

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.

Valid $\underline { \text { multiple-row } }$ operators include =, >, <, >=, <=. _________________________

A group function cannot be included in the SELECT clause of a single-row subquery.

The following SQL statement contains which type of subquery? SELECT title, retail, (SELECT AVG(retail) FROM books) FROM books;

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

A MERGE statement containing an UPDATE and an INSERT clause is also called a(n) ____________________ statement.

In Oracle11g, a(n) ____ allows a series of DML actions to occur.

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

The following SQL statement contains which type of subquery? SELECT title, retail, category, cataverage FROM books NATURAL JOIN (SELECT category, AVG(retail) cataverage FROM books GROUP BY category);

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