The analytic functions provide a way to perform calculations on ____________________ result sets.

The date/time data types can store

When coding a query with two columns in the GROUP BY clause, you can insert a summary row for each major group by coding the ___________________________ operator.

Write an aggregate expression to find the VendorName column that’s last in alphabetical order:_________________________.

You use DDL to create, modify, and delete the ___________________________ of a database.

By default, all duplicate values are included in the aggregate calculation, unless you specify the ___________________________ keyword.

Which ORDER BY clause will cause 10 rows to be retrieved from the result set, starting with the 20th row?

Which of the following is not a reason for using the explicit syntax instead of the implicit syntax for inner joins? The explicit syntax

When you define a foreign key constraint, you can specify all but one of the following. Which one is it?

To run a SELECT statement from an application program, you store the statement in the ____________ object for the database connection.