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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / abhishek jee
Please provide details on the contents of the triggers. That way, we will be able to figure out what the triggers do and how many times they would execute.
Is This Answer Correct ? | 0 Yes | 0 No |
what is datawarehouse? : Sql dba
What is sql in java?
what is a control file ? : Sql dba
What is the size of partition table?
how to check the 3rd max salary from an employee table?
Define tables and fields in a database
What are procedures used for?
How insert into statements in sql?
Which data type doesn't allow null data type?
what are null values? : Sql dba
How does postgresql compare to "nosql"?
What are different types of sql commands?