Java database interview questions

Are you a Database Administrator? Need to update DBA technical knowledge or need to prepare for a job interview? Check out this collection of Java database interview questions...

Java database interview questions

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