What is the advantage of using PreparedStatement

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

6. What is the advantage of using PreparedStatement?

If we are using PreparedStatement the execution time will be less. The PreparedStatement object contains not just an SQL statement, but the SQL statement that has been precompiled. This means that when the PreparedStatement is executed,the RDBMS can just run the PreparedStatement’s Sql statement without having to compile it first.

(Continued on next question...)

Other Job Interview Questions

• What are different types of Transaction Isolation Levels?
• How do you call a Stored Procedure from JDBC?
• Is the JDBC-ODBC Bridge multi-threaded?
• When we will Denormalize data?
• How do you handle your own transaction ?
• How do you handle your own transaction ?
• How do you handle your own transaction ?
• What is the advantage of using PreparedStatement?
• When we will Denormalize data?
• What is 2-phase commit?
• More...