A trigger that fires itself

• A

  It runs once, because a trigger cannot fire on its own statement

• B

  It runs twice and then settles, because the second write finds that the timestamp has not changed

• C

  The trigger fires itself repeatedly until the database stops it at a recursion limit

• D

  It fails immediately, because a trigger may not write to its own table