Ch. 12 Subqueries Flashcards
A(n) ____ subquery is one that can return several rows of results.
- correlated
- single-row
- multiple-row
- uncorrelated
-multiple-row
An outer query is also referred to as a(n) ____ query.
- parent query
- outer view
- outline view
- all of the above
-parent query
The outer query receives its input from the ____.
- inner view
- outer view
- nested function
- subquery
-subquery
The following SQL statement contains which type of subquery?
SELECT title, retail, (SELECT AVG(retail) FROM books)
FROM books;
- single-row
- multiple-row
- multiple-column
- inline view
-single-row
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?
SELECT title FROM books WHERE pubid >ANY
(SELECT pubid FROM books WHERE title = ‘SHORTEST POEMS’);
SELECT title FROM books WHERE pubid =ANY
SELECT pubid FROM books WHERE title = ‘SHORTEST POEMS’;
SELECT title FROM books WHERE pubid IN
(SELECT pubid, title FROM books WHERE title = ‘SHORTEST POEMS’);
none of the above
none of the above
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.
- GROUP BY
- WHERE
- HAVING
- FROM
-HAVING
Which operator will instruct Oracle10g to list all records with a value that is less than the highest value returned by the subquery?
> ANY
ALL
Which of the following operators is the equivalent of the IN comparison operator?
ANY
=ANY
=ALL
=ANY
A temporary table that is created when a multiple-column subquery is used in the FROM clause of an outer query is called a(n) ____.
- inner view
- outer view
- inline view
- natural view
-inline view
Which of the following operators is used with a multiple-row subquery?
- IN
- ANY
- ALL
- all of the above
-all of the above
The = operator is referred to as a(n) ____ operator.
- single-row
- multiple-row
- correlated
- uncorrelated
-single-row
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);
- Line 3
- Line 5
- Line 7
- none of the above
-none of the above
The > operator is referred to as a(n) ____ operator.
- multiple-row
- multiple-column
- single-row
- none of the above
-single-row
Which operator will instruct Oracle11g to list all records with a value that is more than the highest value returned by the subquery?
ALL
>ANY
> ALL
Which of the following must be used to separate a subquery from the outer query?
/ /
“ “
| |
( )
( )
