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
Explain the savepoint statement.
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
how many triggers are allowed in mysql table? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What is meant by temporal data?
how to drop an existing view in mysql? : Sql dba
what are the differences between require and include, include_once and require_once? : Sql dba
how to write date and time literals? : Sql dba
How does stored procedure reduce network traffic?
What is the difference between unique and primary key constraints?
what is auto increment? : Sql dba
What is the process of debugging?
What is a sql trace file?
What is the difference between nested table and varray?
what is the difference between undefined value and null value? : Sql dba