chapter 9 CIST 1601 - 1 The MIN function is used to...

This preview shows page 1 out of 1 page.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Oracle 12c: SQL
The document you are viewing contains questions related to this textbook.
Chapter 12 / Exercise 19
Oracle 12c: SQL
Casteel
Expert Verified
1. The MIN function is used to determine the smallest value in a specified column. A) Tru
2. The following SQL statement contains what type of subquery? SELECT b.title, b.retail, a.category, a.cataverage FROM books b, (SELECT category, AVG(retail) cataverage FROM books GROUP BY category) WHERE b.category = a.category; C) inline view
3. The ____ function can be used to include NULL values in a calculation. D) NVLPoints Earned: 2.0/2.0
4. The JOIN keyword is included in which of the following clauses? B) FROM
5. The equal sign, =, is a valid single-row operator. A) True
6. The TO CHAR function can be used to display insignificant zeros. A) True
7. Which of the following statements about performing DML operations on complex views is
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Oracle 12c: SQL
The document you are viewing contains questions related to this textbook.
Chapter 12 / Exercise 19
Oracle 12c: SQL
Casteel
Expert Verified

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture