Microsoft Exam Questions

What should you do?

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.