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

Answers to Review Questions

1. B, C. If a keypad lock uses separate codes for each individual and stores the date, time, and person inputting the code, then this provides an audit of physical access. Video monitoring provides an audit capability as well.
2. A. Stored procedures are the most useful SQL Server object for preventing SQL injection attacks.
3. A. Since DDL triggers on database-level structures, such as tables and views, are part of the database structure, they will move automatically when you move the database. A detach/attach is the easiest way to accomplish this.
4. A, B. Validating all input and using stored procedures will help to prevent SQL injection attacks. By validating input and using this input as a parameter in a stored procedure, ...