JDBC Interview Questions and Answers

How can you establish connection?
To establish a connection you need to have the appropriate driver connect to the DBMS.
The following line of code we use:

String url = “jdbc:odbc:Fred”;
Connection con = DriverManager.getConnection(url, “Fernanda”, “J8?);

Define different types of Statements?
There are three types of statements
• Regular statement
• prepared statement
• callable statement

What are the components of JDBC?
The two major components of JDBC are Connection Pooling and Data Sources.

Define metadata?
Metadata is data about data.
In JDBC, there are two types
1. Describing information about the Result set object. i
2. describes about the database connection

Differentiate between local and global transaction?
A transaction is atomic unit of Work.

Transactions can be divided into two categories.

1.Local Transactions: These transactions are confined to the objects which reside inside one particular JVM.

2.Global Transactions:These transactions may encapsulate objects which are distributed on various JVM's.

Many More Interview Questions