When you use the CREATE TABLE statement to create a table, you can also define the attributes and _________________________ for the columns of the table.

A view is a/an ______________________________ statement that’s stored as an object in the database.

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.