17. You want to prevent changes to tables in one of the databases in your SQL
Server instance since changes to any of the tables can cause the associated
client application to stop functioning. What can be implemented to prevent
any tables from being changed?
A. A stored procedure
B. A database-level DDL trigger
C. A DML trigger
D. A server-level DDL trigger
The correct answer is B. A database-level DDL trigger can be used to prevent
any modifications to tables. Answer A is incorrect since stored procedures
can only make DDL changes, not prevent them. Answer C is incorrect since
DML triggers can only be used to fire on data INSERTS, UPDATES, and
DELETES. Answer D is incorrect since monitoring changes to tables is outside
the scope of a server-level DDL trigger.
Bạn đang xem 17. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P146 PPS