What is the advantage of using PreparedStatement?
Submitted by: AdministratorIf 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.
Submitted by: Administrator
Submitted by: Administrator
Read Online Java Database Job Interview Questions And Answers
Top Java Database Questions
☺ | Is the JDBC-ODBC Bridge multi-threaded? |
☺ | What is 2-phase commit? |
☺ | How do you get Column names only for a table (SQL Server)? |
☺ | What is a “dirty read”? |
☺ | What is cold backup, hot backup, warm backup recovery? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |