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

What is difference between my sql and sql?

0 Answers  


What is view? Can we update view

0 Answers  


What are different types of tables in sql?

0 Answers  


what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  


what is oltp (online transaction processing)? : Sql dba

0 Answers  


how to get second highest salary in SQL(as/4000

29 Answers   iGate,


create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,


How many sectors are in a partition?

0 Answers  


Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  


What are the different types of database management systems?

0 Answers  


What are pl/sql cursors?

0 Answers  


When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  


Categories