You need to remove BUSINESS_HOUR DB trigger.WHich command in SQL*PLUS environmet is used to delete it?
-
Drop trigger business_hour;
-
delete trigger business_hour;
-
remove trigger business_hour;
-
delete from user_triggers where trigger_name=business_hour;
The SQL command to delete a trigger is DROP TRIGGER trigger_name;. Option D incorrectly uses DELETE FROM on a system table, which is not the proper way to manage database objects. Options B and C use invalid syntax - DELETE and REMOVE are not standard commands for dropping triggers. The DROP TRIGGER command is the correct DDL statement for permanently removing a trigger from the database.
In SQL*Plus/PL-SQL, the DDL statement to remove any trigger is DROP TRIGGER trigger_name; — there is no DELETE TRIGGER or REMOVE TRIGGER statement in SQL, and DELETE FROM ... operates on table rows, not on schema objects like triggers, so it can't be used to drop one.