O'Reilly logo

MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 by Thomas Moore

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Answers to Practice Exam 2

Answer B is correct. The presence of a condition should not affect the addition of an index to the view. You must ensure that the WITH SCHEMABINDING option is performed when creating the view if you are going to be applying indexes. Because this preparatory step had not been completed, it needs to be done. WITH CHECK applies only to data modified through the view and ensures that when a row is modified through a view, the data remains visible through the view after the modification is committed. DROP EXISTING does not apply ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required