Blog

A _____________ is a type of nonclustered index that includes a WHERE clause.

To relate one table to another, a/an __________________ in one table is used to point to the primary key in another table.

You can use a/an ____________________ to generate a series of integer values that can be used by more than one table.

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

Code example 4-2SELECT VendorName, InvoiceNumberFROM Invoices LEFT JOIN Vendors  ON Invoices.VendorID = Vendors.VendorID; (Refer to code example 4-2.) The total number of rows returned by this query must equal

SQL Server comes with complete documentation and reference information called ____________________________________.

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

SQL statements that define the tables in a database are referred to as _______________ statements.

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

A database __________________ is a schematic drawing that shows you the relationships between the tables you’re working with.