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
What is the equal sign?
How do you represent a space in regex java?
What is the base class of all exception classes?
What are the legal operands of the instanceof operator?
Is string passed by reference in java?
Why strings in java are called as immutable?
Difference between stack and queue?
Which number is denoted by leading 0x or 0x in java?
What is a buffer in computer?
Why do we use bufferedreader?
How do you create a null object?
What is meant by javabeans?
What is executor memory?
What should I import for arraylist in java?
Say you want to store the information about a number of pets in an array. Typical information that you could store for each pet (where relevant) would be • Breed of animal • Animal's name • Its birth date • Its sex • Whether it has been sterilised or not • When it is due for its next inoculation • When it last had its wings clipped For each type of pet (eg. dog, cat or bird) you would typically define a class to hold the relevant data. Note: You do not need to implement these classes. Just answer the following questions. 3.1.1 What would be the advantage of creating a superclass (eg. Pet) and declaring an array of Pet objects over simply using an array of Objects, storing each of the instances of the different pet classes (eg. Dog, Cat or Bird) in it? 3.1.2 Would you define Pet as a class or as an interface? Why? (2) (2)