Exam 12: Subqueries and Merge Statements

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 double-quotation marks.

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

IN is not a valid operator for a multiple-column subquery.

A subquery can only be nested in the WHERE or HAVING clause of the outer query.

The following SQL statement contains what type of subqueries? SELECT isbn, title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS') AND retail-cost > (SELECT AVG(retail-cost) FROM books);

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

The following SQL statement contains which type of subquery? SELECT title, retail, category FROM books WHERE retail IN (SELECT MAX(retail) FROM books GROUP BY category);

A single-row subquery can return several columns, but only one row, of results to the outer query.

Which comparison operator allows you to search for NULL values in a subquery?

Contents of the BOOKS table -Based on the contents of the BOOKS table, which of the following SQL statements will display the title of all books published by the publisher of SHORTEST POEMS?

If a subquery's result must be compared with a group function, you must nest the inner query in the ____________________ clause of the outer query.

What is the difference between the IN operator and the =ANY operator?

A subquery must include a(n) ____ clause.

Which of the following subqueries returns more than one row of results to the outer query?

IN is a valid $\underline { \text { multiple-row } }$ subquery operator. _________________________

If the result returned from a subquery must be compared to a group function, then the inner query must be nested in the outer query's ____ clause.

A subquery must be enclosed in a set of $\underline {\text { quotation marks. } }$ _________________________

The following SQL statement contains which type of subquery? SELECT title FROM books WHERE EXISTS (SELECT isbn FROM orderitems WHERE books.isbn = orderitems.isbn);

The NVL function can be used in a subquery.

When a multiple-column subquery is used in the outer query's FROM clause, it creates a temporary table, called an inline view, that can be referenced by other clauses of the outer query.