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 are different types of collation sensitivity? : Sql dba
What is replication id?
what is the stuff function and how does it differ from the replace function? : Sql dba
How do you create a db file?
What is the difference between inner join and left join?
What is a sql select statement?
which operator is used in query for pattern matching? : Sql dba
Are left and right joins the same?
what is collation? : Sql dba
Explain what is table in a database?
Is id a reserved word in sql?
How does one load ebcdic data? : aql loader
Can we join same table in sql?
how to decrement dates by 1 in mysql? : Sql dba
Is left join inner or outer?