Multiple choice

What is the significance of '[OF col_name]' clause in PL/SQL trigger?

  1. This clause is used with update triggers.

  2. It creates a trigger with the given name or overwrites an existing trigger with the same name.

  3. This clause is used to reference the old and new values of the data being changed.

  4. This clause is used to determine whether a trigger must fire when each row gets affected.

  5. This clause is valid only for row level triggers.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This clause is used when one wants to trigger an event only when a specific column is updated.

Keep practicing — related questions