1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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.

Question Posted / neetu

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 the purpose of my sql?

0 Answers  

Where do we use pl sql?

0 Answers  

What is sql resultset?

0 Answers  

What is integrity in sql?

0 Answers  

What are the advantages of stored procedure?

0 Answers  




what is bdb (berkeleydb)? : Sql dba

0 Answers  

How do I truncate a sql log file?

0 Answers  

Can you do multiple joins in sql?

0 Answers  

List different type of expressions with the example.

0 Answers  

Can you select everything, but 1 or 2 fields, without writer's cramp?

0 Answers  

Is mariadb a nosql database?

0 Answers  

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories