Multiple choice technology databases

Which of the following events can be used to fire triggers?

  1. sysdate

  2. Truncate

  3. avg

  4. To_date
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TRUNCATE is a DDL (Data Definition Language) operation that can fire triggers in database systems. Sysdate is a function, avg is an aggregate function, and to_date is a conversion function - none of these are events that fire triggers. Only DDL/DML operations like TRUNCATE can trigger database triggers.

Keep practicing — related questions