YOU WANT TO PREVENT CHANGES TO TABLES IN ONE OF THE DATABASES IN Y...

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.