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



There are 5 records in a table and we have implemented two triggers that are :pre_query and post_que..

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

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_que..

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

Post New Answer

More SQL PLSQL Interview Questions

what is datawarehouse? : Sql dba

0 Answers  


What is sql in java?

0 Answers  


what is a control file ? : Sql dba

0 Answers  


What is the size of partition table?

0 Answers  


how to check the 3rd max salary from an employee table?

23 Answers   IBM,






Define tables and fields in a database

0 Answers  


What are procedures used for?

0 Answers  


How insert into statements in sql?

0 Answers  


Which data type doesn't allow null data type?

6 Answers   TCS,


what are null values? : Sql dba

0 Answers  


How does postgresql compare to "nosql"?

0 Answers  


What are different types of sql commands?

0 Answers  


Categories