🎴 Flashcard Mode
Database Triggers and ETL Transformations
Card1 / 20
Mastered0
Review0
QuestionClick to flip
You need to remove BUSINESS_HOUR DB trigger.WHich command in SQL*PLUS environmet is used to delete it?
AnswerClick to flip back
A
Drop trigger business_hour;
💡 Explanation:
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.