Java Database Connectivity interview questions
Java Database Connectivity interview questions
Take as many assements as you can to improve your validate your skill rating
Total Questions: 15
1. Which of the following is correct about driver interface of JDBC?
Correct Answer is : Both of the above.
2. In which of the following type of ResultSet, the cursor can only move forward in the result set?
Correct Answer is : ResultSet.TYPE_FORWARD_ONLY
3. Which of the following type of JDBC driver, is also called Type 2 JDBC driver?
Correct Answer is : Native-API, partly Java driver
4. Which of the following type of JDBC driver is typically used for development and testing purposes only?
Correct Answer is : Type 1
5. Which of the following is used to call stored procedures on the database?
Correct Answer is : CallableStatement
6. Which of the following contains both date and time?
Correct Answer is : java.util.dateTime
7. Which of the following is advantage of using JDBC connection pool?
Correct Answer is : Better performance
8. Which of the following is advantage of using PreparedStatement in Java?
Correct Answer is : Prevents SQL injection
9. Which one of the following contains date information?
Correct Answer is : java.sql.TimeStamp
10. What does setAutoCommit(false) do?
Correct Answer is : does not commit transaction automatically after each query
11. Which of the following is used to call stored procedure?
Correct Answer is : CallableStatment
12. Which of the following is used to limit the number of rows returned?
Correct Answer is : setMaxRows(int i)
13. Which of the following is method of JDBC batch process?
Correct Answer is : addBatch()
14. Which of the following is used to rollback a JDBC transaction?
Correct Answer is : rollback()
15. Which of the following is not a JDBC connection isolation levels?
Correct Answer is : TRANSACTION_NONREPEATABLE_READ
