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 is oltp (online transaction processing)? : Sql dba
what is self join and what is the requirement of self join? : Sql dba
What are three advantages to using sql?
Explain the difference between triggers and constraints?
When can we use the where clause and the having clause?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What are the operators in sql?
How does a self join work?
What are the advantages of stored procedure?
What is difference between nchar and nvarchar?
How do I install sql?
How do you write an inner join query?
what is the bond code in materialized view?
Explain commit, rollback and savepoint.
How does a covering index work?