试题详情
单项选择题 You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database.  What should you do？（）

A、Implement a stored procedure that writes data about schema changes to a log table.

B、Implement DDL AFTER triggers that write user and schema information to a log table.

C、Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.

D、Implement a DML AFTER trigger that writes data about schema changes to a log table.

  • B

  • 关注下方微信公众号，在线模考后查看

热门试题