Deni Ace

Section 9 Quiz             (Answer all questions in this section)                                                             1.         If you want to include subtotals and grand totals for all columns mentioned in a GROUP BY clause, you should use which of the following extensions to the GROUP BY clause?       Mark for Review (1) Points             HAVING             ROLLUP             CUBE (*) ...

Section 8 Quiz             (Answer all questions in this section)                                                             1.         The AVG, SUM, VARIANCE, and STDDEV functions can be used with which of the following?    Mark for Review (1) Points             All except numeric             Only numeric data types (*)             Integers only            ...