ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
Maximum how many triggers can be updated in table ?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Maximum how many triggers can be updated in table ?
Answer
# 1
12
 
Is This Answer Correct ?    1 Yes 2 No
Kavitha
 
  Re: Maximum how many triggers can be updated in table ?
Answer
# 2
System Privileges Related To Table Triggers
create trigger
create any trigger
administer database trigger
alter any trigger
drop any trigger

Table Trigger Firing Options
-- before constraints are applied
BEFORE INSERT
BEFORE UPDATE
BEFORE DELETE

-- after constraints are applied
AFTER INSERT
AFTER UPDATE
AFTER DELETE
 
Is This Answer Correct ?    0 Yes 1 No
Ora
 
 
 
  Re: Maximum how many triggers can be updated in table ?
Answer
# 3
The oracle table can have the 12 Trigger associated with it.

-- before constraints are applied

1) BEFORE INSERT STATEMENT LEVEL
2) BEFORE INSERT ROW LEVEL
3) BEFORE UPDATE STATEMENT LEVEL
4) BEFORE UPDATE ROW LEVEL
5) BEFORE DELETE STATEMENT LEVEL
6) BEFORE DELETE ROW LEVEL


7)  AFTER INSERT STATEMENT LEVEL
8)  AFTER INSERT ROW LEVEL
9)  AFTER UPDATE STATEMENT LEVEL 
10) AFTER UPDATE ROW LEVEL
11) AFTER DELETE STATEMENT LEVEL
12) AFTER DELETE ROW LEVEL
 
Is This Answer Correct ?    4 Yes 0 No
Khushal
 
  Re: Maximum how many triggers can be updated in table ?
Answer
# 4
depend on the  structure of tables
 
Is This Answer Correct ?    1 Yes 0 No
Rohit
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario? Wipro2
What are the composite date types in oracle?  2
what is the use of ondelete cascade?  1
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?  1
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou  7
how to insert data into partitioned table partition done by Range partition  1
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me? Philips1
What is cursor TCS4
What is a Temporary Segment ?  2
what is the difference between dbms and rdbms? Oracle2
What are Schema Objects ?  1
What is the diff between Oracle and SQL Server  1
can u call user defined functions in select statements  2
Define 'view' advantage ? AZTEC2
why can't we assign not null constraint as table level constraint CTS2
What is forall Statement ? Thermotech2
HOW CAN RETURN MAX DATE ROW A B C D E 1 2 1-Mar-09 5 10 1 2 10-Mar-09 5 10 ONLY USING ORACLE PREDEFINED FUNCTION. NOT USER DEFINED. OUTPUT:-- A B C D E 1 2 10-Mar-09 5 10  1
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records  1
What is TNS File Thermotech4
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL  1
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com