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.

The ranking functions make it easy to include a column in a result set that provides the sequential ranking number of each row within a/an ___________________________.

Write the code for an ORDER BY clause that sorts a table into numeric sequence by the data in the PartCode column if that column contains whole numbers that are stored with the varchar data type: _____________________________________________________