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. Which of the following would ensure audit capability for physical access to your server? (Choose two.)
    1. A door secured by a key lock
    2. A door secured by a keypad lock
    3. Video monitoring of the data center
    4. A backup generator
  2. What type of SQL Server object is most useful in preventing SQL injection attacks?
    1. Stored procedure
    2. Function
    3. SELECT query
    4. INSERT/UPDATE/DELETE queries
  3. You are moving your Sales database from ServerA to ServerB. Inside the database are a series of DDL triggers to prevent tables and views from being altered. You want to be sure that these triggers are still enforced on the new server. What is the easiest way to do this?
    1. Move the database using a detach/attach procedure.
    2. Script out the triggers, back up and ...

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