What is the maximum number of triggers that can be defined for a given table?

What is the maximum number of triggers that can be defined for a given table?

What is the maximum number of triggers that can be defined for a given table?

A.
Three triggers can be defined per table: 1 each for INSERT, UPDATE, and DELETE. The trigger must be defined to occur either before or after the event.

B.
Six triggers can be defined per table: 2 each for INSERT, UPDATE, and DELETE, combined with a definition of whether they occur before or after the event.

C.
A maximum of 128 triggers can be defined for a table, irrespective of update type and when they occur.

D.
A maximum of 1024 triggers can be defined for a table, irrespective of update type and when they occur.

E.
The number of triggers that may be defined for a table are in practice only limited by the amount of disk space available.



Leave a Reply 0

Your email address will not be published. Required fields are marked *