Microsoft Exam Questions

You need to ensure that tables are not dropped from your database

You need to ensure that tables are not dropped from your database.
What should you do?

A.
Create a DDL trigger that contains COMMIT.

B.
Create a DML trigger that contains COMMIT.

C.
Create a DDL trigger that contains ROLLBACK.

D.
Create a DML trigger that contains ROLLBACK.