Which command accomplished this?

You disabled all triggers on the EMPLOYEES table to perform a data load. Now, you need to
enable all triggers on the EMPLOYEES table. Which command accomplished this?

You disabled all triggers on the EMPLOYEES table to perform a data load. Now, you need to
enable all triggers on the EMPLOYEES table. Which command accomplished this?

A.
You cannot enable multiple triggers on a table in one command.

B.
ALTER TRIGGERS ON TABLE employees ENABLE;

C.
ALTER employees ENABLE ALL TRIGGERS;

D.
ALTER TABLE employees ENABLE ALL TRIGGERS;

Explanation:
To enable or disable a single Trigger you issue the following Command at the Trigger Level:
ALTER TRIGGER TriggerName ENABLE|DISABLE TriggerName;



Leave a Reply 0

Your email address will not be published. Required fields are marked *