Multiple choice technology platforms and products

What is true about trigger?

  1. Explicity fired.

  2. Not taking space in database.

  3. Only DML triggers are there.

  4. Trigger timing is mandatory.

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Trigger timing (BEFORE, AFTER, INSTEAD OF) is a mandatory attribute when defining triggers in Oracle. Option A is incorrect because triggers are implicitly fired by events. Option B is incorrect - triggers do occupy space in the database. Option C is incorrect - there are also DDL and system event triggers.