JDBC Interview Questions and Answers

JDBC Interview Questions and Answers

JDBC Stands for Java Database Connectivity. JDBC AI used to connect java application with Database. JDBC API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases & SQL databases and other tabular data sources, such as spreadsheets or flat files.

What is JDBC?

What are the types of statements in JDBC?

What is JDBC Driver?

What are different types of JDBC Drivers?

What are the steps to connect to the database in java?

What are the JDBC API components?

What is the difference between Statement and PreparedStatement interface?

What are the benefits of PreparedStatement over Statement?

What is the limitation of PreparedStatement and how to overcome it?

What are different types of ResultSet?

How to rollback a JDBC transaction?

What is JDBC Savepoint? How to use it?

What is JDBC DataSource and what are it’s benefits?

What is rowset?

What are the different types of RowSet?

What is the different between ResultSet and RowSet?

What are common JDBC Exceptions?

What is CLOB and BLOB datatypes in JDBC?

What are the different types of locking in JDBC?

What are the standard isolation levels defined by JDBC?

What are the package new features changes in JDBC?