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 re-enable 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 command
B & C are incorrect syntax for disabling a Trigger