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...

  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

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  

For more SQL PLSQL Interview Questions Click Here
Categories