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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Java J2EE  >>  Java Related  >>  JDBC
 
 


 

 
 Core Java interview questions  Core Java Interview Questions
 Advanced Java interview questions  Advanced Java Interview Questions
 Swing interview questions  Swing Interview Questions
 EJB interview questions  EJB Interview Questions
 Servlets interview questions  Servlets Interview Questions
 Struts interview questions  Struts Interview Questions
 JDBC interview questions  JDBC Interview Questions
 JMS interview questions  JMS Interview Questions
 SunOne interview questions  SunOne Interview Questions
 J2EE interview questions  J2EE Interview Questions
 Weblogic interview questions  Weblogic Interview Questions
 Websphere interview questions  Websphere Interview Questions
 Java Networking interview questions  Java Networking Interview Questions
 Java J2EE AllOther interview questions  Java J2EE AllOther Interview Questions
Question
Diff. types of triggers..
 Question Submitted By :: Rdharmendra
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Diff. types of triggers..
Answer
# 1
static trigger
the icon or window background is clicked or double-clicked
without moving the mouse

dynamic trigger
the icon is dragged and dropped onto another icon or window
background

hold trigger
the mouse button is held down on an icon or window background
 
Is This Answer Correct ?    2 Yes 4 No
Dev
 
  Re: Diff. types of triggers..
Answer
# 2
There are mainily 3 types of triggers
1> DML Trigger
2> Instead of Trigger written on only view
3> System Trigger

DML Trigger written on table that gets fired on DML events 
like
   insert or delete or update operation
that trigger may fire 
  1> After dml event 
  2> Before dml event these are timings for trigger firing

Instead of trigger written only on view that view is not 
modifiable that also gets fired
 when dml event occurs

System trigger gets fired on system event like 
 before log off or after log on or before shutdown
this trigger  may be written on 
  Database level
  Schema level
 
Is This Answer Correct ?    0 Yes 1 No
Pratap
 
 
 
  Re: Diff. types of triggers..
Answer
# 3
Basically there are three types of triggers,

Row and statement triggers
Before and after triggers
Insteadof triggers

Possible combination of these triggers 
Before row trigger
After row trigger
Before statement trigger
After statement trigger

Instead of trigger is mainly for a view.
if we want to write a trigger in such a way that the 
trigger action is to be on underlying base tables of a view,
when an DML statement (insert,update,delete)is issued
 
Is This Answer Correct ?    1 Yes 0 No
K. A. Purushotham
 
  Re: Diff. types of triggers..
Answer
# 4
1) Action
2) Event
3) Condition
 
Is This Answer Correct ?    0 Yes 0 No
Rakesh N
 

 
 
 
Other JDBC Interview Questions
 
  Question Asked @ Answers
 
How warnings are retrieved in JDBC?  1
Is there any limitation for no of statments executed with in batchupdate? HSBC2
What is de-normalization?  1
How to store images in database?  1
How do you debug PL/SQL code?  1
Explain the different ways to register a driver?  2
In JDBC, All the API?s are interfaces? Where is the actual implementation? HCL2
write down exceptions those appear in java programs when u write JDBC Programs?  2
what is rowset? Marlabs3
What is the difference between Union, Unionall ?  1
How to find that, a row is updated or not?  2
Hi friends, In JDBC 4 drivers are there among this which driver is best and why it is best.Which driver is most commonly used in web applications.  6
What is an outer join? Infogain2
What is the difference between Minus, and Intersect?  1
Without using of Class.forName(? ?), how do you connect to db? IBM2
What is PreparedStatement? Infogain5
Does multiple concurrent open statements per connection are supported by the JDBC-ODBC Bridge?  2
What is Type-4 Driver and when this driver is used?  3
I have written a program to connect to database using odbc.Can this Application run on any Platform????  1
Difference between Dirty, commited ,phantom,repeatable reads?  2
 
For more JDBC 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