Oracle
1Z0-147 · Question #10
You need to remove the database trigger BUSINESS_HOUR. Which command do you use to remove the trigger in the SQL*Plus environment?
The correct answer is A. DROP TRIGGER business_hour. See the full explanation below for the reasoning.
Question
You need to remove the database trigger BUSINESS_HOUR. Which command do you use to remove the trigger in the SQL*Plus environment?
Options
- ADROP TRIGGER business_hour;
- BDELETE TRIGGER business_hour;
- CREMOVE TRIGGER business_hour;
- DALTER TRIGGER business_hour REMOVE;
- EDELETE FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'BUSINESS_HOUR';
How the community answered
(55 responses)- A82% (45)
- B2% (1)
- C5% (3)
- D9% (5)
- E2% (1)
Community Discussion
No community discussion yet for this question.