🎴 Flashcard Mode
DB2 and Oracle Database Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which statment about trigger is TRUE ?
AnswerClick to flip back
A
we can use database Trigger to fire when a INSERT statement occurs
💡 Explanation:
Database triggers are stored programs that execute automatically in response to specific events on a table or view. Option A is incorrect because Application Trigger is not a standard database trigger type. Option B is correct - database triggers CAN fire when an INSERT statement occurs (among other DML operations). Option C is incorrect - system event triggers fire for DDL or database events, not DML DELETE. Option D is incorrect - INSTEAD OF triggers fire on views, not directly on INSERT statements to tables.