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

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

how to write date and time literals? : Sql dba

0 Answers  

What is indexes?

0 Answers  

Write a query to get last 10 records from the table.

12 Answers   iNautix,

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,




What is dml and ddl?

0 Answers  

What is an exception in pl/sql?

0 Answers  

What is the purpose of using pl/sql?

0 Answers  

How can we link a sql database to an existing android app?

0 Answers  

What is function and procedure?

0 Answers  

What is string join?

0 Answers  

What is the difference between delete and truncate commands?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories