JDBC PROGRAMMING MCQs – CHAPTER 8 DAE 14 min Score: 0 Attempted: 0/14 Subscribe 1. . What are the types of ResultSet in JDBC? (A) Both a and b (B) Scrollable ResultSet (C) Only a (D) Forward ResultSetShow All Answers 2. . Select the packages in which JDBC classes are defined? (A) jdbc and javax.jdbc (B) rdb and javax.rdb (C) sql and javax.sql (D) jdbc and java.jdbc.sqlShow All Answers 3. . Which of the following method is used to perform DML statements in JDBC? (A) executeResult() (B) executeQuery() (C) executeUpdate() (D) execute()Show All Answers 4. . How many transaction isolation levels are provided by JDBC through the Connection interface? (A) 3 (B) 2 (C) 7 (D) 4Show All Answers 5. . Which of the following method is static and synchronized in JDBC API? (A) executeUpdate() (B) prepareCall() (C) getConnection() (D) executeQuery()Show All Answers 6. . Which methods are required to load a database driver in JDBC? (A) Both b and c (B) registerDriver() (C) forName() (D) getConnection()Show All Answers 7. . Parameterized queries can be executed by? (A) ParameterizedStatement (B) CallableStatement and Parameterized Statement (C) PreparedStatement (D) All kinds of StatementsShow All Answers 8. . Which of the following is not a valid statement in JDBC? (A) Statement (B) PreparedStatement (C) QueryStatement (D) CallableStatementShow All Answers 9. . Stored procedure can be called by using the ______. (A) CallableStatement (B) PreparedStatement (C) CalledStatement (D) StatementShow All Answers 10. . A good way to debug JDBC-related problems is to enable ______. (A) JDBC tracing (B) Exception handling (C) Both a and b (D) Only bShow All Answers 11. . Which JDBC driver can be used in servlet and applet both? (A) Type 3 (B) Type 3 and Type 4 (C) Type 3 and Type 2 (D) Type 4Show All Answers 12. . JDBC-ODBC driver is also known as? (A) Type 1 (B) Type 3 (C) Type 4 (D) Type 2Show All Answers 13. . How many stages are used by Java programmers while using JDBC in their programs? (A) 3 (B) 2 (C) 6 (D) 5Show All Answers 14. . How many ways to register a driver? (A) 4 (B) 3 (C) 2 (D) 5Show All Answers
