Oracle
1Z0-147 · Question #42
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 accomplishes this?
The correct answer is D. D. ALTER TABLE employees ENABLE ALL TRIGGERS. See the full explanation below for the reasoning.
Question
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 accomplishes this?
Options
- AA. You cannot enable multiple triggers on a table in one command.
- BB. ALTER TRIGGERS ON TABLE employees ENABLE;
- CC. ALTER employees ENABLE ALL TRIGGERS;
- DD. ALTER TABLE employees ENABLE ALL TRIGGERS;
How the community answered
(20 responses)- A10% (2)
- B15% (3)
- C5% (1)
- D70% (14)
Community Discussion
No community discussion yet for this question.