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  >>  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 bet.. Function and Trigger?
 Question Submitted By :: Rdharmendra
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Diff bet.. Function and Trigger?
Answer
# 1
Function returns the value.Trigger is not complusory return 
the value.
 
Is This Answer Correct ?    1 Yes 4 No
Dsr
 
  Re: Diff bet.. Function and Trigger?
Answer
# 2
Triggers: are special class of stored procedures to execute 
automatically when an update,insert or statement is issued 
against a table or view.
Function:Function is used to return value after performing 
the tasks to the callable fucntion.
 
Is This Answer Correct ?    11 Yes 0 No
Srinivas T
 
 
 
  Re: Diff bet.. Function and Trigger?
Answer
# 3
PL/SQL has two types of sub programs
Function and Procedures.
A Trigger is a stored procedure which is implictly called 
by the oracle engine when an DML action is performed.
Trigger consists of three parts
A trigger statement
A trigger restriction
and the triggering action

Functions are different from procedures as
functions return value whereas procedure doesnt
To carry out set of tasks a certain pl/sql statements are 
grouped in a procedure.
After performing some tasks and returns the result(function)
functions are written explicitly by the user.
 
Is This Answer Correct ?    0 Yes 0 No
Purushotham
 

 
 
 
Other JDBC Interview Questions
 
  Question Asked @ Answers
 
what are the Different types of exceptions in JDBC?  1
How to handle when the database crashes while reading the data from the database? IBM1
What is the difference between ExecuteUpdate and ExecuteQuery?  1
I have written a program to connect to database using odbc.Can this Application run on any Platform????  1
What is JDBC and ODBC and what are the differences between them? TCS9
How to store images in database?  1
Is there any limitation for no of statments executed with in batchupdate? HSBC2
what is callable statement? Infogain5
What type of driver called is pure Java driver? Vertex3
What is Type-1 Driver and when this driver is used?  3
What are stored procedures? How to call them?  3
commit() and rollback() methods are defined in which interface?  4
What are the different types of 2 tier and 3 tier architecture ?  2
how to prevent finally block from execution Bosch3
Different statements in JDBC?  2
What are the different types of modifiers?  1
What is Type-3 Driver and when this driver is used? Wipro3
How does JDBC differ from ODBC?  7
What is the difference between Union, Unionall ?  1
When you will get error like ?No suitable driver??  1
 
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