A SELECT statement that includes aggregate functions is often called a/an _____________________________ query.

The rows in a table are kept in the sequence that’s based on its  __________________________ index.

The ________________ clause of the SELECT statement names the table that contains the data to be retrieved.

In most cases, the join condition of an inner join compares the primary key of one table to the ____________________ key of another table.

A view is a SELECT statement that is stored with the ______________.

To maintain _________________________________, if you delete a row in a primary key table, you must also delete any related rows in foreign key tables.

The IIF function determines the value it returns based on a/an ____________________ expression.

When you use Windows authentication to connect to a database, SQL Server

You can create a database diagram for

The SQL dialect that Microsoft SQL Server uses is called _______________.