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

Review Questions

  1. Your server has recently shown some instability in input/output operations. You want to make certain your ClinFarm database that resides on the server is configured so that any pages read from disk are validated automatically, with any errors detected written to the Windows Event Log. You need to configure the database options. What should you do?
    1. Set the PAGE_VERIFY option to NONE.
    2. Set the PAGE_VERIFY option to TORN_PAGE_DETECTION.
    3. Set the PARAMETERIZATION option to FORCED.
    4. Set the PAGE_VERIFY option to CHECKSUM.
  2. You are validating a new drug serum for a study. You must provide a method to ensure that the value in the drug dosage column is between 25 and 40 mm. You have set the column nullability to not allow nulls. What ...

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