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.

Discuss the significances of JDBC?

Name the new features added in JDBC 4.0?

How do Java applications access the database using JDBC?

Briefly tell about the JDBC Architecture?

Explain the life cycle of JDBC?

Describe how the JDBC application works?

How a database driver can be loaded with JDBC 4.0 / Java 6?

What does the JDBC Driver interface do?

What is represented by the connection object?

What is a Statement?

Define PreparedStatement

Differentiate between a Statement and a PreparedStatement

What is the function of setAutoCommit?

How do we call a stored procedure from JDBC?

What is SQLWarning and discuss the procedure of retrieving warnings?

Explain the types of JDBC Drivers and name them

How can we move the cursor in a scrollable result set?

How do we load the drivers?

What Class.forName does, while loading the drivers?

How can you make a connection?