Multiple choice

With reference to OLD and NEW pseudorecords, which of the following statements is FALSE ?

  1. For an INSERT trigger, OLD contains no value and NEW contains new values.

  2. For an ALTER trigger, OLD contains the old values, and NEW contains the new values.

  3. For an UPDATE trigger, OLD contains the old values, and NEW contains the new values.

  4. For a DELETE trigger, OLD contains old values, and NEW contains no value.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ALTER is a DDL statement and triggers are written on execution of a DML statement. Therefore, we cannot create a trigger that fires when an Alter statement is issued.

Keep practicing — related questions