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


What are nested triggers ?

Answers were Sorted based on User's Feedback



What are nested triggers ?..

Answer / subhendu

Triggers are nested when a trigger performs an action that
initiates another trigger, which can initiate another
trigger, and so on. Triggers can be nested up to 32 levels,
and you can control whether triggers can be nested through
the nested triggers server configuration option.

Is This Answer Correct ?    52 Yes 2 No

What are nested triggers ?..

Answer / sunil kumar

Nested triggers are fired due to actions of other triggers.
For example, you delete a row from TableA. A trigger on
TableA deletes row from TableB. Because you are deleting
rows from TableB,a trigger is executed on TableB to record
the deleted row is called nested trigger.........

Is This Answer Correct ?    5 Yes 1 No

What are nested triggers ?..

Answer / srikanth

A trigger that contains data modification logic within
itself is called a nested trigger.

Use the nested triggers option to control whether an AFTER
trigger can cascade; that is, perform an action that
initiates another trigger, which initiates another trigger,
and so on. When nested triggers is set to 0, AFTER triggers
cannot cascade. When nested triggers is set to 1 (the
default), AFTER triggers can cascade to as many as 32
levels. INSTEAD OF triggers can be nested regardless of the
setting of this option.

Is This Answer Correct ?    4 Yes 11 No

What are nested triggers ?..

Answer / vzxcgv

zdDSGFD

Is This Answer Correct ?    1 Yes 9 No

What are nested triggers ?..

Answer / sudipta tripathy

A nested table is a table that appears as a
column in another table.But we can perform
the same operation on it as on other table.

Is This Answer Correct ?    2 Yes 29 No

What are nested triggers ?..

Answer / anil_abbireddy

A table is created with in the table is called nested table

Is This Answer Correct ?    3 Yes 33 No

Post New Answer

More SQL PLSQL Interview Questions

How does sql store data?

0 Answers  


What is PL/SQL table ?

6 Answers  


Explain what is a column in a table?

0 Answers  


what is an index? : Sql dba

0 Answers  


I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,


Is sql the best database?

0 Answers  


1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,


What packages(if any) has oracle provided for use by developers?

1 Answers  


Can procedure in a package be overloaded?

1 Answers   HCL,


How do I delete a trigger?

0 Answers  


how can create data base link for tow servers (scott schema) give examples plz

2 Answers  


how to create a test table in your mysql server? : Sql dba

0 Answers  


Categories