What is the main functionality of Prepared Statement?

Answers were Sorted based on User's Feedback



What is the main functionality of Prepared Statement?..

Answer / kathir

prepared statement is a precomplie SQL statement.It is the
compiled version of the query.Prepared statement has got a
faster excecution time than any other statement.

Is This Answer Correct ?    7 Yes 2 No

What is the main functionality of Prepared Statement?..

Answer / madhu

it is wrong assumption that preparedStatement is precompiled statement,because when we send any query with prepared statement it is going to store in SGA memory and it select any algorithm to find the solution.when we send the same query second time it won't compile once again.in this it going to improve performance.for the first time it is not precompiled for the second it is precompiled.
i hope is correct, if any thing wrong suggest me.

Is This Answer Correct ?    4 Yes 1 No

What is the main functionality of Prepared Statement?..

Answer / arjun

when client send any query first time it can go to database
after second time no need to connect directly connect
database that is the functionality

Is This Answer Correct ?    1 Yes 1 No

What is the main functionality of Prepared Statement?..

Answer / md sirajuddin

Prepared Statement is an interface , which is used to execute queries . In case of prepared Statement we can insert the data dynamically to the query , prepared statement is used to execution query multiple times.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Core Java Interview Questions

What is the purpose of static methods and variables?

0 Answers  


What is the basic concept of java?

0 Answers  


explain the collection in java

1 Answers   WDC,


How many methods does cloneable interface contains?

6 Answers  


Outline the major features of java.

0 Answers  






why doesn't java run on all platforms?

0 Answers  


What is difference between stringbuffer and string?

0 Answers  


What is the difference between hashmap and hashtable? What is an interface?

0 Answers  


how to minimize the functionality to will not force garbage collector?

2 Answers  


What are the names of interfaces that doesn't consists of method/s ?

3 Answers  


How do you include a string in java?

0 Answers  


What is method in java with example?

0 Answers  


Categories