What is the main functionality of Prepared Statement?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is t type java?

620


Which package has light weight components?

553


what is meant by HQL?

637


Where are variables stored?

546


What is string data type?

544






What is the vector class in java programming?

555


Explain all java features with real time examples

1202


How many static init can you have?

669


What is module in oop?

559


Is 64bit faster than 32 bit?

571


java Technical questions asked by JPMC

4564


What is the purpose of static methods and static variables?

534


What is a string what operation can be performed out with the help of a string?

502


What are the different ways of creating thread?

562


What is default size of arraylist in java?

549