MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide

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 ...