Multiple choice technology databases

You need to remove BUSINESS_HOUR DB trigger.WHich command in SQL*PLUS environmet is used to delete it?

  1. Drop trigger business_hour;

  2. delete trigger business_hour;

  3. remove trigger business_hour;

  4. delete from user_triggers where trigger_name=business_hour;
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To drop a trigger in SQL*Plus (or Oracle SQL), use the DROP TRIGGER command followed by the trigger name. Option B uses DELETE which is for removing data rows, not schema objects. Option C's REMOVE is not valid SQL syntax. Option D attempts to delete from data dictionary views directly, which is incorrect and would fail.

Keep practicing — related questions