Java Database Interview Questions

 
1.
How do you call a Stored Procedure from JDBC?
2.
Is the JDBC-ODBC Bridge multi-threaded?
3.
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
4.
What is 2-phase commit?
5.
When we will Denormalize data?
6.
What is cold backup, hot backup, warm backup recovery?
7.
What is a �dirty read�?
8.
What is the advantage of using PreparedStatement?
9.
What is Metadata and why should I use it?
10.
What are different types of Transaction Isolation Levels?
11.
How do you handle your own transaction?
12.
What is the normal procedure followed by a java client to access the db?
13.
What is a data source (DS)?
14.
What are collection pools? What are the advantages?
15.
How do you get Column names only for a table (SQL Server)?