Stored procedure purpose?

Question Posted / guest

2 Answers
5863 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Stored procedure purpose?..

Answer / samsudeen

Hi Desika, pls undesrstand the question, he/she asking the
purpose of SP.

1) Stored Procudure is a collection of sql statements
2) Faster then Sql Qury
3) Preformance Tuning
4) resuable.

Is This Answer Correct ?

4 Yes

0 No

Stored procedure purpose?..

Answer / desika

A Stored Procedure is used to separate business logic from
Presentation logic,advantage of implementing a business
logic as storedprocedures improves the performance and we
can use same code for the applications written in other
languages.

Is This Answer Correct ?

3 Yes

2 No

Post New Answer

More JDBC Interview Questions

How can we execute stored procedures using callablestatement?

0 Answers

MY code is: public class P1{ public static void main(String ar[]) { class.forName("java.lang.String"); } } errors i got are :New.java:5: error: <identifier> expected class.forName("java.lang.String"); ^ New.java:5: error: invalid method declaration; return type required class.forName("java.lang.String"); ^ New.java:5: error: illegal start of type class.forName("java.lang.String"); ^ New.java:7: error: reached end of file while parsing } ^ 4 errors HELP ME>......

3 Answers

Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.

0 Answers

What are types of jdbc drivers?

0 Answers

What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?

0 Answers

is java pure object oriented or not ?

7 Answers

What are the main steps in java to make JDBC connectivity?

0 Answers UGC Corporation,

What are the different types of statements in jdbc?