JDBC Quiz

Which of the following is not true about JDBC-ODBC Bridge Driver?

• It uses ODBC driver to connect to the database
• It converts JDBC method calls into the ODBC function calls
• Performance is upgraded because JDBC method call is converted into the ODBC function calls.
• It can be easily connected to any database

Identify the correct way to instantiate DatabaseMetaData object:

• DatabaseMetaData ob = new DatabaseMetaData();
• DatabaseMetaData ob = connection.getDatabaseMetaData();
• DatabaseMetaData ob = connection.getMetaData();
• DatabaseMetaData ob = resultset.getDatabaseMetaData();

Which of the following Statement interface is the best option to choose for calling procedures with OUT parameters from DB?

• Statement
• PreparedStatement
• CallableStatement
• All the above

Which of the following is advantage of using PreparedStatement in Java?

• It allows different arguments to run on the same execution plan
• It increases the performance
• it is more secure with binding variables and avoids sql injection
• All the above

Which method is used to stop the action of committing every sql statement as it is executed from statement object?

• con.setAutoCommit(true)
• con.setAutoCommit(false)
• con.commit()
• con.commit(true)

Which of the following methods are used for batch processing?

• addBatch() and execute()
• addBatch() and executeBatch()
• setBatch() and execute()
• setBatch() and executeBatch()

Which all of the below actions are done by the Statement object of JDBC?

A Statement object encapsulates an SQL statement which is passed to the database to be

1. parsed

2. compiled

3. planned

4. executed

• 1,2,3,4
• 1,2,3
• 2,3,4
• 1,2,4

Which is the more optimal function to execute the below query?

"delete from test"

• execute()
• executeUpdate()
• executeQuery()
• none

Which method of result object is called to set the pointer to read the records?

• setPointer()
• hasNext()
• next()
• getXXX()

Which interface contains a table of data representing the result of a SQL query executed?

• ResultSet
• ResultSetMetaData
• DatabaseSet
• DatabaseMetaData