Multiple choice technology databases

Q9

  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

In database triggers (Oracle/PLSQL), trigger timing (BEFORE/AFTER/INSTEAD OF) is a mandatory clause. Every trigger must specify when it fires relative to the DML event. Options A, B, and C are incorrect - triggers can be implicit/automatic, they occupy space in database, and DML/DDL triggers both exist.