Exam 12: Subqueries and Merge Statements

Multiple-row subqueries are nested queries that can return more than one row of results to the parent query.

The results of a subquery are passed back as input to the ____ query.

A(n) correlated subquery references one or more columns $\underline { \text { FROM } }$ the outer query. _________________________

Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values, rather than as individual values?

A subquery nested in a SELECT clause cannot contain an ORDER BY clause.

Which of the following must be used to separate a subquery from the outer query?

Contents of the BOOKS table -Based on the contents of the BOOKS table, which line in the following SQL statement contains an error? 1 SELECT title 2 FROM books 3 WHERE pubid EXISTS IN 4 (SELECT pubid 5 FROM books 6 WHERE retail > 41.95);

A(n) ____ subquery is one that can return several rows of results.

In Oracle11g, subqueries in a WHERE clause can be nested to a depth of $\underline { 2 }$ . _________________________

The $\underline {\text { IN } }$ operator can be used with single-row, multiple-row, or multiple-column subqueries. _________________________

When a multiple-column subquery is used in the WHERE clause of the outer query, the column names listed on the left side of the comparison operator must be enclosed in $\underline {\text { single-quotation marks }}$ . _________________________

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

Contents of the BOOKS table -Based on the contents of the BOOKS table, which line of the following SQL statement contains an error? 1 SELECT isbn, title 2 FROM books 3 WHERE pubid = 4 (SELECT pubid 5 FROM books 6 WHERE title = 'SHORTEST POEMS') 7 AND retail-cost > 8 (SELECT AVG(retail-cost) 9 FROM books);

The outer query receives its input from the ____.

The equal sign, =, is a valid single-row operator.

The <ALL operator indicates that for a value to be included in the results, it must be less than the lowest value returned by the subquery.

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

The $\underline { \text { EXISTED } }$ operator is used to determine whether a condition is present in a subquery. _________________________

A multiple-column subquery nested in the $\underline {\text { SELECT } }$ clause of the outer query is known as an inline view. _________________________

A single-row subquery can be nested in the SELECT clause of the outer function.