Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

How many columns should be in an index?

0 Answers  


What is indexing oracle sql?

0 Answers  


What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers  


What is Histogram?

0 Answers   NIIT,


What is difference between sql and mysql?

0 Answers  


How delete all records from table in sql?

0 Answers  


How does sql*loader handles newline characters in a record? : aql loader

0 Answers  


How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,


What are different methods to trace the pl/sql code?

0 Answers  


What are the benefits of triggers?

0 Answers  


Explain the difference between 'between' & 'and' operators in sql

0 Answers  


How do you optimize a query?

0 Answers  


Categories