🎴 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.

Change Mode