You need to disable all triggers on the EMPLOYEES table.Which command accomplishes this?
A.
None of these commands; you cannot disable multiple triggers on a table in one command.
B.
ALTER TRIGGERS ON TABLE employees DISABLE;
C.
ALTER employees DISABLE ALL TRIGGERS;
D.
ALTER TABLE employees DISABLE ALL TRIGGERS;
Explanation:
You can disable all triggers using the ALTER TABLE command. The syntax to disable or reenable all triggers on a particular table is:
ALTER TABLE <table name> DISABLE | ENABLE ALL TRIGGERS
Incorrect Answers:
A: This is not true, you can disable all triggers on a table using the ALTER TABLE commandB & C
are incorrect syntax for disabling a Trigger