You need to remove the database triggerBUSINESS_HOUR. Which command do you use to remove the trigger in the SQL *Plus environment?
A.
DROP TRIGGER business_hour;
B.
DELETE TRIGGER business_hour;
C.
REMOVE TRIGGER business_hour;
D.
ALTER TRIGGER business_hour REMOVE;
E.
DELETE FROM USER_TRIGGERS
WHERE TRIGGER_NAME = ‘BUSINESS_HOUR’;
Explanation:
To permanently remove a trigger from a database, you can use the DROP TRIGGER statement. The
syntax of this statement is:
DROP TRIGGER ;
B, C & D: Are invalid and will return an error
E: This statement would attempt to delete a record from the USER_Triggers View