What is an index?

Does an index slow down updates on indexed columns?

What is a constraint?

How many indexes does SQL Server allow you to have on a table?

What command would you use to create an index?

Is there a difference between an index and a constraint?

What is the default ordering that will be created by an index (ascending or descending)?

When can the UNIQUE option be used?

What does the IGNORE NULL option do?

How do you delete an index?

What does the NOT NULL constraint do?

What command must you use to include the NOT NULL constraint after a table has already been created?

When a PRIMARY KEY constraint is included in a table, what other constraints does this imply?

What is a concatenated primary key?

How are the UNIQUE and PRIMARY KEY constraints different?

What is a referential integrity constraint? What two keys does the referential integrity constraint usually include?

What is a foreign key?

What does the ON DELETE CASCADE option do?

What does the ON UPDATE NO ACTION do?

Can you use the ON DELETE and ON UPDATE in the same constraint?