Interested to Buy Any Domain ? << Click Here >> for more details...
Stored procedure purpose?
- 2 Answers
- 5794 Views
- I also Faced
- E-Mail Answers
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 do you understand by DDL and DML statements?
Can you create an index on sex column where there is M or F?
How to set the attribute concurrency in resultset?
What is an advantage of using the jdbc connection pool?
What is addbatch jdbc?
What are the different types of statements? How we can you use preparedstatement.
What are the classes and methods used for sending sql statements to database?
Is jdbc and orm?
What is jdbc databasemetadata interface?
How many types of JDBC drivers are there and what are they?
Does jdbctemplate use prepared statements?
How do you debug PL/SQL code?
Core Java 
