JDBC Interview Questions and Answers

Prepare for your Interview today!

Test your skills through the online practice test: JDBC Quiz Online Practice Test

Related differences

1
2
3
4
5
6

Ques 11. What does setAutoCommit do?

When a connection is created, it is in auto-commit mode. This means that each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed. The way to allow two or more statements to be grouped into a transaction is to disable auto-commit mode:
con.setAutoCommit(false);

Once auto-commit mode is disabled, no SQL statements will be committed until you call the method commit explicitly.

con.setAutoCommit(false);
PreparedStatement updateSales =
con.prepareStatement( "UPDATE EMPLOYEE SET SAL = ? WHERE EMP_NAME LIKE ?");
updateSales.setInt(1, 50000); updateSales.setString(2, "Arindam");
updateSales.executeUpdate();
PreparedStatement updateTotal =
con.prepareStatement("UPDATE EMPLOYEE SET TOTAL = TOTAL + ? WHERE EMP_NAME LIKE ?");
updateTotal.setInt(1, 50000);
updateTotal.setString(2, "Arindam");
updateTotal.executeUpdate();
con.commit();
con.setAutoCommit(true);

Is it helpful? Yes No Add Comment View Comments

Ques 12. How do you call a stored procedure from JDBC?

The first step is to create a CallableStatement object. As with Statement an and PreparedStatement objects, this is done with an open
Connection object. A CallableStatement object contains a call to a stored procedure.
CallableStatement cs = con.prepareCall("{call SHOW_EMPLOYEES}");
ResultSet rs = cs.executeQuery();

Is it helpful? Yes No Add Comment View Comments

Ques 13. What is Connection pooling?

Connection pooling is a technique used for sharing server resources among requesting clients. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. Connection pool manager maintains a pool of open database connections.

Is it helpful? Yes No Add Comment View Comments

Ques 14. Is JDBC-ODBC bridge multi-threaded?

No

Is it helpful? Yes No Add Comment View Comments

Ques 15. Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

No

Is it helpful? Yes No Add Comment View Comments

1
2
3
4
5
6

Most helpful rated by users:

About Withoutbook

This site contains most of the quality computer technologies which can help all the related students and employees. We have large number of interview questions and answers, online test, difference between on many subjects.

Copyright © 2024, WBook Technologies.

JDBC vs Hibernate	JDBC vs JPA	JDBC 3.0 vs JDBC 4.0