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.
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