Home › Quizzes › JDBC Database Connectivity

JDBC Database Connectivity

Test your knowledge of Java Database Connectivity (JDBC) including drivers, connections, statements, prepared statements, result sets, and SQL execution methods.

10 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

In which of the following the primary function is to connect java applications to the correct JDBC driver?

  1. JDBC driver manager
  2. JDBC-ODBC bridge
  3. JDBC URL
  4. JDBC
  5. The java 2 ORB
Question 2 Multiple Choice (Single Answer)

Which of the following drivers is most appropriate on a corporate network where client installations are not a problem?

  1. JDBC-ODBC bridge ODBC driver
  2. JDBC-ODBC bridge
  3. JDBC-Net pure java driver
  4. Transaction
  5. JDBC URL
Question 3 Multiple Choice (Single Answer)

Which of the following driver coverts JDBC calls into calls on the client application programming interface for Oracle, Sybase etc?

  1. Alarm
  2. JDBC URL
  3. Native-API partly java driver
  4. JDBC-Net pure java driver
  5. JDBC-ODBC bridge
Question 4 Multiple Choice (Single Answer)

Which one of the following has a group of methods, which sets the value of IN parameters?

  1. Trader
  2. PreparedStatement
  3. Statement
  4. Stock
  5. Next()
Question 5 Multiple Choice (Single Answer)

Which of the following methods is used to access data from the ResultSet rows?

  1. getInputStream()
  2. getXXX()
  3. executeQuery()
  4. next()
  5. statement
Question 6 Multiple Choice (Single Answer)

To establish a connection with a database, you need to register the ODBC-JDBC driver by calling____________.

  1. stock
  2. forName()
  3. next()
  4. executeQuery()
  5. getInputStream()
Question 7 Multiple Choice (Single Answer)

Which of the following techniques mixes simple and advanced features together and it has complex options even for simple queries?

  1. JDBC URL
  2. JDBC
  3. ODBC
  4. JDBC-ODBC bridge
  5. Event
Question 8 Multiple Choice (Single Answer)

Which of the followings provides some confidence that JDBC drivers will run your program?

  1. StockHelper.java
  2. JDBC driver test suite
  3. JDBC-ODBC bridge
  4. JDBC
  5. JDBC URL
Question 9 Multiple Choice (Single Answer)

Which of the following drivers allows a direct call from the client machine to the database management server?

  1. Native-protocol pure java driver
  2. The java 2 ORB
  3. JDBC URL
  4. JDBC-ODBC bridge
  5. JDBC-Net pure java driver
Question 10 Multiple Choice (Single Answer)

Which of the following methods executes an SQL statement that may return multiple results?

  1. stock
  2. getInputStream()
  3. execute()
  4. executeQuery()
  5. next()
← Back to Quizzes