Question

Triggers can be enabled or disabled with the ________ statement.

(a) ALTER TABLE statement

(b) DROP TABLE statement

(c) DELETE TABLE statement

(d) None of the mentioned

I had been asked this question in an interview for job.

This is a very interesting question from DML Triggers in section Developing with SQL Server of SQL Server

Answer 1

Correct option is (a) ALTER TABLE statement

To elaborate: You can also use the ALL keyword instead of a trigger name to enable/disable all of the triggers on a table in question.