Stored procedure purpose?
Answers were Sorted based on User's Feedback
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 |
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 |
What are the different types of 2 tier and 3 tier architecture ?
Which Java and java.sql data types map to my specific database types?
Why should we close database connections in java?
State the three different ways in which you can create a table?
How to insert an image or raw data into database?
How vendor Naming registry supports JNDI?
How to rollback a JDBC transaction?
Explain the various types of locking system in jdbc?
How many isolation levels are supported in JDBC and what are they?
What are the jdbc drivers in java?
r u used any design patterns in your project?
What are the types of statements in jdbc?