JDBC interview Questions

What is 2 phase commit?

Distributed transactions are performed by relational databases. To ensure each and every transaction to perform in an orderly manner, a process is implemented. This process is called Two Phase Commit. In this process, the transactions termination occurs either by committing or rolling back them.

Also read

Java Threading

What is a thread? What are the advantages we derived by programming with thread?
Explain how to create a thread and start it running.
How does thread’s stop method work.
How do we specify pause times in my program?...........

JNDI, Java naming and directory interfaces

What is a naming service?
What is a directory service?
What is LDAP?............

OFBiz Service Engine

Defining and creating a Java service 
Service parameters 
Special unchecked (unmatched) IN/OUT parameters 
Security-related programming 
Calling services from code (using dispatcher) 
IN/OUT parameter mismatch when calling services 
Sending feedback; standard return codes success, error and fail 
Implementing Service Interfaces 
Synchronous and asynchronous services 
Using the Service Engine tools 
ECAs: Event Condition Actions

ONLY QUESTIONS

What is JDBC? 

Difference between Type-2 and Type-3 driver 

How can you make the connection? 

What is a transaction ? 

How to get the resultset of stroedProcedure ? 

How can you create JDBC statements? 

What is the difference between JDBC 1.0 and JDBC 2.0 ? 

What is the purpose of setAutoCommit( ) ? 

How can store images in a data base? 

How can you retrieve data from the ResultSet ? 

What are the two major components of JDBC ? 

What are the three statements in JDBC & differences between them ? 

Why do we use prepared statement when already statement is present ? 

What are the different types of Statements? 

What is JDBC Driver interface ? 

What is stored procedure. How do you create stored procedure ? 

How can you use PreparedStatement ? 

What are the common tasks of JDBC ? 

What are batch updates ? 

How to call a Stored Procedure from JDBC ? 

What packages are used by JDBC ? 

What is the difference between Resultset and Rowset ? 
How to Retrieve Warnings ? 

What are the flow statements of JDBC ? 

What are the steps for connecting to the database using JDBC ? 

How to Make Updates to Updatable Result Sets ? 

What are the steps involved in establishing a connection ? 

What is Connection Pooling ? 

"select * from user" .what are the steps to take for execution of query in JDBC ? 

How can you load the drivers ? 

How do you implement Connection Pooling ? 

What Class.forName will do while loading drivers ? 

What Class.forName( ) method will do ? 

1

2

3

4

5

6

7

8