Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

51.

What are types of ResultSet?

Answer»

There are three constants which when defined in result set can move cursor in resultset backward, forward and also in a particular row.

  • ResultSet.TYPE_FORWARD_ONLY − The cursor can only move forward in the result set.

  • ResultSet.TYPE_SCROLL_INSENSITIVE − The cursor can scroll forwards and backwards, and the result set is not sensitive to changes made by others to the database that occur after the result set was created.

  • ResultSet.TYPE_SCROLL_SENSITIVE − The cursor can scroll forwards and backwards, and the result set is sensitive to changes made by others to the database that occur after the result set was created.
Discussion
52.

What is a ResultSet?

Answer»

These objects hold data retrieved from a database after you execute an SQL query using Statement objects. It acts as an iterator to allow you to move through its data. The java.sql.ResultSet interface represents the result set of a database query.
Discussion
53.

What is a connection?

Answer»

Connection interface consists of methods for contacting a database. The connection object represents communication context.
Discussion
54.

What is a JDBC Driver?

Answer»

JDBC driver is an interface enabling a Java application to interact with a database. To connect with individual databases, JDBC requires drivers for each database. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between client and database.
Discussion
55.

What is a JDBC DriverManager?

Answer»

JDBC DriverManager is a class that manages a list of database drivers. It matches connection requests from the java application with the proper database driver using communication subprotocol.
Discussion
56.

What are the common JDBC API components?

Answer»

JDBC API consists of following interfaces and classes DriverManager, Driver, Connection, Statement, ResultSet, SQLException.
Discussion
57.

Describe a general JDBC Architecture.

Answer»

General JDBC Architecture consists of two layers JDBC API (This provides the application-to-JDBC Manager connection) and JDBC Driver API (This supports the JDBC Manager-to-Driver Connection).
Discussion
58.

What is JDBC?

Answer»

JDBC stands for Java Database Connectivity, which is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases.
Discussion