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,"

MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: