Oracle
1Z0-144 · Question #105
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
(32 responses)- A81% (26)
- B6% (2)
- C3% (1)
- D9% (3)
Community Discussion
No community discussion yet for this question.