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 driver should I use for scalable Oracle JDBC applications?

0 Answers  


What is a statement in java?

0 Answers  


How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?

0 Answers  


What is the use of statement in jdbc?

0 Answers  


What is the purpose of the jdbc resultset interface?

0 Answers  






What is a Connection?

1 Answers  


r u used any design patterns in your project?

3 Answers   Wipro,


Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

0 Answers  


How many ways that we can view a result set?

0 Answers  


What are the Normalization Rules?

2 Answers  


What happens if connection is not closed in jdbc?

0 Answers  


What are cursor attributes?

3 Answers  


Categories