CIST1220 FINAL EXAM RESULTS - CIST1220 FINAL EXAM RESULTS 1...

This preview shows page 1 - 2 out of 4 pages.

CIST1220 FINAL EXAM RESULTS 1. The MIN function is used to determine the smallest value in a specified column.
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;
3. The ____ function can be used to include NULL values in a calculation.
4. The JOIN keyword is included in which of the following clauses?
5. The equal sign, =, is a valid single-row operator.
6. The TO CHAR function can be used to display insignificant zeros.
7. Which of the following statements about performing DML operations on complex views is correct?
8. A view based on the contents of one table that uses an expression for one of the columns is considered a(n) ____ view.
9. The only group function that includes NULL values by default is the MIN function.
10. Which of the following keywords is used to create a Cartesian join?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture