Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how many triggers we can create on a table

Answers were Sorted based on User's Feedback



how many triggers we can create on a table..

Answer / karthikeyan.v

You can create a maximum of 12 triggers on a table
3*2*2=12
insert/delete/update3
before/after2
row/statement-2

Is This Answer Correct ?    93 Yes 13 No

how many triggers we can create on a table..

Answer / karthik

Hi Aurobinda and Karthikeyan,
see all says the same answer which is NOT right.u can hv
many number of triggers ina table but the COMBINATIONS U
CAN MAKE can be 12 only(karthikeyan ur partly rit)
ex: i can hv before insert on each row trigger 5 times ina
table it means this itself its a 5 trigger but the
combination can be 12 only.

Is This Answer Correct ?    56 Yes 3 No

how many triggers we can create on a table..

Answer / damodar

12 is the correct answer.

Is This Answer Correct ?    16 Yes 7 No

how many triggers we can create on a table..

Answer / ash

Limited by resources.
12 types as above. each type is limited by resources.

Is This Answer Correct ?    16 Yes 11 No

how many triggers we can create on a table..

Answer / krishna shekhar

we can create 12 triggers on table.

Is This Answer Correct ?    10 Yes 6 No

how many triggers we can create on a table..

Answer / sumedh tayade

Maximum 12 Trigger can be applied on a single table.

Is This Answer Correct ?    4 Yes 2 No

how many triggers we can create on a table..

Answer / krishna

12 triggers

Is This Answer Correct ?    8 Yes 8 No

how many triggers we can create on a table..

Answer / samir

You can have 1 each INSTEAD OF trigger for INSERT, UPDATE,
and DELETE.

You can have as many AFTER triggers as you want up to the
limit of the total maximum number of SQL Server objects.

Within AFTER triggers, you can have only 1 FIRST and 1 LAST
trigger for INSERT, UPDATE, and DELETE.

This information is available in Books Online
under "Triggers".

Is This Answer Correct ?    5 Yes 6 No

how many triggers we can create on a table..

Answer / mohit74

acc. to me only 12 trigger combination is there but we can
have more then 12 triggers on table

and the ppl talking abt instead of trigger----guys instead
of trigger is for view not for table so dont get confused.

Is This Answer Correct ?    6 Yes 8 No

how many triggers we can create on a table..

Answer / irene

255

Is This Answer Correct ?    9 Yes 18 No

Post New Answer



More Oracle General Interview Questions

What is a data lock in oracle?

0 Answers  


Which of the following is not a database object TABLESPACE TABLE INDEX NONE

1 Answers  


What is Rollback Segment ?

3 Answers  


Can we call a trigger inside a function and function inside a trigger? Give example.

1 Answers   Metric Stream,


how to hide the stored procedure inside a package

1 Answers  






How to increment dates by 1 in oracle?

0 Answers  


Explain the use of show option in imp command.

0 Answers  


Why we choose emp number as primarykey?

4 Answers  


Explain integrity constraints?

0 Answers  


What is different bet native dynamic sql and Dbms_Sql?

4 Answers   Thermotech,


What would you use to improve performance on an insert statement that places millions of rows into that table?

1 Answers  


Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)