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 <trigger name>;
B, C & D. Are invalid and will return an error
E: This statement would attempt to delete a record from the USER_Triggers View