Question

Point out the wrong statement.

(a) DDL trigger can be used to observe and control actions performed on the server, and to audit these operations

(b) DML trigger can be used to observe and control actions performed on the server, and to audit these operations

(c) DDL triggers can be used to manage administrator tasks such as auditing and regulating database operations

(d) None of the mentioned

The question was posed to me in final exam.

I want to ask this question from DDL Triggers topic in division Developing with SQL Server of SQL Server

Answer 1

Correct answer is (b) DML trigger can be used to observe and control actions performed on the server, and to audit these operations

The explanation: DDL triggers are a special kind of trigger that fire in response to Data Definition Language (DDL) statements.