Multiple choice technology databases

You need to remove the database trigger T1. Which command do you use to remove the trigger in the SQL *Plus environment?

  1. DROP TRIGGER T1

  2. DELETE TRIGGER T1

  3. ALTER TRIGGER T1 DISABLE

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To remove a database trigger, use DROP TRIGGER trigger_name command. DELETE TRIGGER is not valid SQL. ALTER TRIGGER DISABLE would disable but not remove the trigger. DROP TRIGGER is the correct DDL command for permanent removal in SQL*Plus.

AI explanation

DROP TRIGGER T1 is the correct SQL*Plus command to permanently remove a trigger from the database. DELETE TRIGGER isn't valid SQL syntax, and ALTER TRIGGER T1 DISABLE only deactivates the trigger without removing it — the trigger definition still exists and can be re-enabled later.

Keep practicing — related questions