What is the main functionality of Prepared Statement?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How to make a non daemon thread as daemon?
Scenario: There are 1 to 100 numbers. Each number should be keep in the each column like from A column to Z column ie 1 to 26. From 27 to 52 should be in 2nd row in the excel sheet. This has to be continue till 100. How do you write Java program and what are various methods.
Is there a way to increase the size of an array after its declaration?
What is a predicate method?
What is memory leak and how does java handle it?
Difference between notify() method and notifyall() method in java?
What are filterstreams?
what is meant by multicast?
What are other modifiers?
What is I/O Filter?
What do you mean by append?
What happens if a constructor is declared private?