Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is the use of prepared statement?Ans:used to execute
pre compiled statement...so the question is when that
precompiled statement will be execute or
comiple?................

Answers were Sorted based on User's Feedback



What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question..

Answer / suri

when we sent a sql stmt in to oracle sever the server
splits statemts in to mutiple stmts, checks wheather valid
or not, if it is valid it is stored in the shared pool,
where as in the normal stmt parsing will be done every time
in prepared parsing will be done only once, naxt time
onwards values will be sent to the place holders

Is This Answer Correct ?    7 Yes 0 No

What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question..

Answer / anjani kumar jha

prepared statement work same as the statement,but there r
some differences.

wen u submitting the query first time following things happened
1)compiling the query
2)executing the query
3)sending results back to the program

2nd time onwards
1)executing the query directly
2) sending results back to the program

Is This Answer Correct ?    6 Yes 1 No

What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question..

Answer / narasimha rao bodagala

Hey this is an interface.

in the jdbc API they designed all the interface. which you
can use any interface based on that you can create the
implemented class method.

for this you can call in the core java design
pattern..abstract factory pattren..

you can try to see the API you can understand more.

preparedstatement---pre compiled statement.

first time it's compile and second time it will pass
dynamically.

make sure that should be done in DB side only once.

one time compile and next time passing the values into the
query then execute.

overall story behind this one time compile many times execute.

Is This Answer Correct ?    3 Yes 0 No

What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question..

Answer / nagashree

Prepared statements are used due to its 2 advantages.

Advantages:
1) We can give dynamic values.
2) The statement will be compiled only once, it need not be
compiled each & every time we give new values.

Is This Answer Correct ?    3 Yes 2 No

What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question..

Answer / ricky

can someone tell me how does preparedstatement works? its
an interface and where is the implementation?

Is This Answer Correct ?    1 Yes 0 No

What is the use of prepared statement?Ans:used to execute pre compiled statement...so the question..

Answer / syed sadhik

It’s just pre compile SQL while run time it’s execute query.

Is This Answer Correct ?    0 Yes 7 No

Post New Answer



More JDBC Interview Questions

What is new in JDBC 2.0?

0 Answers  


How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?

0 Answers  


what is connection pooling?

6 Answers   Wipro,


When do we get java.sql.SQLException: No suitable driver found?

0 Answers  


What is JDBC Savepoint? How to use it?

0 Answers  






How do I insert/update records with some of the columns having NULL value?

0 Answers  


what is call level interface?

1 Answers  


Diff. types of triggers..

4 Answers   Logica CMG,


What are the ddl statements?

0 Answers  


Expalin the method of calling a stored procedure from jdbc.

0 Answers  


how can connection with oracle10g with java

3 Answers   IonIdea,


Is oracle client required for jdbc connection?

0 Answers  






Categories