The difference between the CAST function and the CONVERT function is that the ______________________________ function accepts an optional style argument that lets you specify a format for the result.

To delete an existing view, you use the ______________________________ statement.

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