There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
Answer Posted / dinesh
This is depends on which type of trigger we have create.If Statement level then it will fire 2 times and for row level it will fire 10 time maximum and depends on number of record updated.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What does fetching a cursor do?
What does select count (*) mean in sql?
Is trigger a stored procedure?
Define join and name different types of joins?
What does the sign mean in sql?
When should I use nosql database?
Is sql open source?
What is the difference between the sql*loader and import utilities? : aql loader
What are functions in sql?
How do I view stored procedures?
What is the non-clustered index in sql?
What is sql dialect?
Can we debug stored procedure?
explain what is mysql? : Sql dba
Which is faster truncate or drop?