Question 25

Answers A and C are correct. The WITH SCHEMABINDING argument of the CREATE INDEX statement is needed when creating an indexed view. When WITH SCHEMABINDING is specified, tables participating in the indexed view are prevented from being altered or deleted. Alteration of names for a dynamic view is irrelevant, and index type is of no consequence.

For more information, see the following sources:

• Chapter 2, "Creating Database Objects," and Chapter 3, "Implementing Database Objects"

• SQL Server 2005 Books Online: "Creating and Maintaining Databases, Views, Creating a View, Creating an Indexed View"

• "Improving Performance with SQL Server 2005 Indexed Views," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/indexedviews1.asp