# Which clause is used when the group results of a

• Test Prep
• 18
• 95% (20) 19 out of 20 people found this document helpful

This preview shows page 7 - 10 out of 18 pages.

##### We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
The document you are viewing contains questions related to this textbook.
Chapter 2 / Exercise 5
Programming Logic and Design, Introductory
Farrell
Expert Verified
16. Which clause is used when the group results of a subquery need to be restricted, based on some condition? a. GROUP BY c. WHERE b. HAVING d. ORDER BY ANS: B PTS: 1 REF: 434
##### We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
The document you are viewing contains questions related to this textbook.
Chapter 2 / Exercise 5
Programming Logic and Design, Introductory
Farrell
Expert Verified
8 17. 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); PTS: 1 REF: 429 18. 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. PTS: 1 REF: 434 19. The following SQL statement contains which type of subquery? SELECT title, retail, (SELECT AVG(retail) FROM books) FROM books; PTS: 1 REF: 435 20. Which of the following operators is used with a multiple-row subquery? a. IN c. ALL b. ANY d. all of the above ANS: D PTS: 1 REF: 438 21. A(n) ____ subquery is one that can return several rows of results. PTS: 1 REF: 437 22. The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery. PTS: 1 REF: 438 23. 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? PTS: 1 REF: 438
9 24. 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 c. multiple-column b. multiple-row d. correlated ANS: B PTS: 1 REF: 438 25. Which operator will instruct Oracle11 g to list all records with a value that is more than the highest value returned by the subquery? PTS: 1 REF: 439 26. The >ALL operator indicates that a value must be ____ value returned by the subquery. PTS: 1 REF: 439 27. The <ALL operator indicates that a value must be ____ value returned by the subquery. PTS: 1 REF: 439