Stored procedure purpose?

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 does a custom RowSetReader get called from a CachedRowSet?

0 Answers  


What is resultset in jdbc with example?

0 Answers  


How can a java objects be stored in database?

3 Answers   IBM,


What is jdbc databasemetadata interface?

0 Answers  


If iam using JDBC API, do I also have to use ODBC?

1 Answers  






What are the common tasks of JDBC?

0 Answers  


State the different connection methods used for creating different types of sql.

0 Answers  


What are restrictions on triggers?

0 Answers  


Explain the importance of drivermanager.

0 Answers  


Why resultset is used in java?

0 Answers  


What is a Connection?

1 Answers  


What happens if connection is not closed in jdbc?

0 Answers  


Categories