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 rows will return from dual table?

4 Answers   Fujitsu,

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

Can we commit inside a trigger?

0 Answers  

Explain the uses of a database trigger?

0 Answers  

what are the differences between binary and varbinary? : Sql dba

0 Answers  

how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

What is a boolean in sql?

0 Answers  

What does pl sql stand for?

0 Answers  

What are tables in sql?

0 Answers  

Explain about various levels of constraint.

0 Answers  

how to enter binary numbers in sql statements? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories