DOes this question have any sense
Q. Minimum to Minimum how many triggers can be associated with a table and fired when using it
Choices :A. 9 B. 10 C. 11 D. 12 ANS: D

I don't understand the question but here are some numbers

Triggers per table Limited by number of objects in a database
Nested trigger levels 32

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

This is the SQL Language forum. Questions about limits or capacities are always dependent upon the specific SQL implementation. In fact, I'm aware of no such numbers which are present in the SQL language specification (nor should there be).

For example, SqlMenace above cites limits particular to SQL Server. They may be quite different for, say, Oracle.

So, the question asked makes no sense unless it is relative to a specific SQL database implementation.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com