O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

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

Answers to Review Questions

  1. D. You should set the PAGE_VERIFY option to CHECKSUM. The CHECKSUM option creates a checksum for a database when it is written to disk, writing it in the header of the database page file. The checksum is recomputed as the page is read from disk and compared to the header value. Unmatched values assume a physical damage in the data with an error being written to the event log. TORN_PAGE_DETECTION ensures only hardware reliability by detecting write errors, and NONE gives no protection. Setting the PARAMETERIZATION option to FORCED converts any literal value appearing in a SELECT, INSERT, UPDATE, or DELETE statement to be converted to a parameter during query compilation.
  2. B. You should create a check constraint comparing ...

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