What is the difference between triggers and procedures?



What is the difference between triggers and procedures?..

Answer / sangeeta

Triggers are group of SQL statements which are executed
automatically in response to the DML ie. Data Manipulation
Language - insert / update / delete.

Procedures are also group of SQL statements submitted
together to the server for execution. Unlike triggers
Procedures have to be executed explicitly.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More JDBC Interview Questions

what are design patterns?

3 Answers   CFC, TCS, Wipro,


What is odbc jdbc?

0 Answers  


Why resultset is used in java?

0 Answers  


Explain the difference between resultset and rowset in jdbc

0 Answers  


What should be done for auto generating primary key id in a table ?

0 Answers  






Difference between JDBC and Hibernate? Give one sample based on the variance?

4 Answers   HCL, IBM, Xybion,


How many types of JDBC Drivers are present and what are they?

0 Answers  


give me a java code snippet to connect Microsoft excel through.... I am trying alot... plz help me.

7 Answers  


what is JDBC?

3 Answers   Wipro,


What is jdbc in dbms?

0 Answers  


What is the function of setautocommit?

0 Answers  


how to prevent finally block from execution

4 Answers   Bosch,


Categories