JDBC Mock Test II - Tutorialspoint

1 mock TESTJDBC mock TESTThis section presents you various set of mock tests related to JDBC Framework. You candownload these sample mock tests at your local machine and solve offline at your mock test is supplied with a mock test key to let you verify the final score and grade mock TEST IIJDBC mock TEST IIQ 1 - Which of the following type of JDBC driver, is also called Type 3 JDBC driver?A - JDBC-ODBC Bridge plus ODBC driverB - Native-API, partly Java driverC - JDBC-Net, pure Java driverD - Native-protocol, pure Java driverQ 2 - Which of the following type of JDBC driver, is also called Type 4 JDBC driver?A - JDBC-ODBC Bridge plus ODBC driverB - Native-API, partly Java driverC - JDBC-Net, pure Java driverD - Native-protocol, pure Java driverQ 3 - Which of the following type of JDBC driver should be used when you areaccessing one type of database, such as Oracle, Sybase, or IBM?A - Type 1B - Type 2C - Type 3D - Type 4Q 4 - Which of the following type of JDBC driver should be used if your Java applicationis accessing multiple types of databases at the same time?

2 A - Type 1B - Type 2C - Type 3D - Type 4Q 5 - Which of the following type of JDBC driver should be used where a type 3 or type4 driver is not available yet for your database?A - Type 1B - Type 2C - Type 3D - Type 4Q 6 - Which of the following type of JDBC driver is typically used for development andtesting purposes only?A - Type 1B - Type 2C - Type 3D - Type 4Q 7 - Which of the following type of JDBC driver is the fastest one?A - Type 1B - Type 2C - Type 3D - Type 4Q 8 - The JDBC-ODBC Bridge support multiple concurrent open statements - trueB - falseQ 9 - Which of the following is not the standard isolation levels defined by JDBC?A - TRANSACTION_NONEB - TRANSACTION_READ_COMMITTEDC - TRANSACTION_READ_UNCOMMITTEDD - TRANSACTION_WRITE_UNCOMMITTEDQ 10 - Which of the following is not the standard isolation levels defined by JDBC?A - TRANSACTION_NONEB - TRANSACTION_REPEATABLE_READC - TRANSACTION_SERIALIZABLED - TRANSACTION_REPEATABLE_WRITEQ 11 - Which of the following is correct about JDBC?

3 A - JDBC architecture decouples an abstraction from its - JDBC follows a bridge design - Both of the - None of the 12 - Which of the following is correct about JDBC?A - The JDBC API provides the abstraction and the JDBC drivers provide the - New drivers can be plugged-in to the JDBC API without changing the client - Both of the - None of the 13 - Which of the following is correct about JDBC?A - The JDBC API provides the abstraction and the JDBC drivers provide the - New drivers can be plugged-in to the JDBC API without changing the client - Both of the - None of the 14 - Which of the following is not a valid type of statement in JDBC?A - StatementB - PreparedStatementC - CallableStatementD - QueryStatementQ 15 - Which of the following represents a regular SQL statement in JDBC?A - StatementB - PreparedStatementC - CallableStatementD - None of the 16 - Which of the following is efficient than statement due to pre-compilation ofSQL?

4 A - StatementB - PreparedStatementC - CallableStatementD - None of the 17 - Which of the following is used to call stored procedures on the database?A - StatementB - PreparedStatementC - CallableStatementD - None of the 18 - Which of the following is correct about PreparedStatement?A - Prepared statements offer better performance, as they are - Prepared statements reuse the same execution plan for different arguments rather thancreating a new execution plan every - Prepared statements use bind arguments, which are sent to the database - All of the 19 - Which of the following is correct about PreparedStatement?A - PreparedStatement allows mapping different requests with same prepared statement butdifferent arguments to execute the same execution - Prepared statements are more secure because they use bind variables, which can preventSQL injection - Both of the - None of the 20 - Which of the following is correct about method call?

5 A - This method dynamically loads the driver's class file into memory, which automaticallyregisters - This method is preferable because it allows you to make the driver registration configurableand - Both of the - None of the 21 - Which of the following is correct about methodcall?A - This method is used to register the database - This static method is used in case you are using a non-JDK compliant JVM, such as the oneprovided by - Both of the - None of the 22 - Which of the following is correct about JDBC - Auto loading of JDBC driver class. In the earlier versions we had to manually register and loaddrivers using - Connection management enhancements. New methods added to - Both of the - None of the 23 - Which of the following is correct about JDBC - DataSet Implementation of SQL using - SQL XML - Both of the - None of the 24 - Which of the following executes the any kind of SQL statement?

6 A - boolean executeB - ResultSet executeQueryC - int executeUpdateD - None of the 25 - Which of the following is used generally for reading the content of thedatabase?A - boolean executeB - ResultSet executeQueryC - int executeUpdateD - None of the SHEETANSWER SHEETQ uestion NumberAnswer Key1C2D3D4C5B6A7D8B9D10C11C12C13C14D15A1 6B17C18D19C20C21C22C23C24A25 BLoading [MathJax]/jax/output/HTML.