In SQL, which command(s) is(are) used to enable/disable a database trigger?

The correct answer is: A. ALTER TRIGGER

An SQL trigger is a database object that is executed automatically when a specified event occurs on a table. Triggers can be used to enforce referential integrity, audit changes to data, and perform other tasks.

To enable or disable a trigger, you use the ALTER TRIGGER statement. The syntax for the ALTER TRIGGER statement is as follows:

ALTER TRIGGER trigger_name {ENABLE | DISABLE};

For example, to enable the trigger named "my_trigger" on the table named "my_table", you would use the following statement:

ALTER TRIGGER my_trigger ENABLE;

To disable the trigger named "my_trigger" on the table named "my_table", you would use the following statement:

ALTER TRIGGER my_trigger DISABLE;

The ALTER TRIGGER statement can also be used to modify the properties of a trigger, such as its name, the table on which it is defined, and the events that it fires on.

The following options are incorrect:

• B. ALTER DATABASE: The ALTER DATABASE statement is used to modify the properties of a database, such as its name, size, and location.
• C. ALTER TABLE: The ALTER TABLE statement is used to modify the properties of a table, such as its name, columns, and constraints.
• D. MODIFY TRIGGER: The MODIFY TRIGGER statement is not a valid SQL statement.