Which clause is used when the group results of a

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.
Programming Logic and Design, Introductory
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.
Programming Logic and Design, Introductory
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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture