Test Status
      JDBCRANDOMTEST
      (A) a
      (B) b
      (C) c
      (D) d
      (A) TRANSACTION_READ_ COMMITTED
      (B) TRANSACTION_UNREAD_ COMMITTED
      (A) Both Type 1 and Type 3
      (B) Both Type 1 and Type 2
      (C) Both Type 3 and Type 4
      (D) Type 4 only
      (A) CallableStatement clbstmnt = con.prepareCall("{call totalStock}");cs.executeQuery();
      (B) Statement stmt = connection.createStatement();stmt.execute("totalStock()");
      (C) StoreProcedureStatement spstmt = connection.createStoreProcedure("totalStock()");spstmt.executeQuery();
      (D) PrepareStatement pstmt = connection.prepareStatement("totalStock()");pstmt.execute();
      (A) Regular Statement
      (B) Interim Statement
      (C) Callable Statement
      (D) Prepared Statement
      (A) A Type 3 driver is a JDBC-Net pure Java driver
      (B) This translates JDBC calls into a database -dependent net protocol.
      (C) Vendors of database middleware products can implement this type of driver into their products to provide interoperability with the greatest number of database servers.
      (D) a,b
      (A) Type 4 driver is "native protocol, pure java" driver
      (B) Type 4 drivers can not be used with Netscape
      (C) Type 4 drivers are 100% Java compatible
      (D) Type 4 drivers uses Socket class to connect to the database
      (A) Native-protocol, pure Java driver
      (B) JDBC-Net, pure Java driver
      (C) Native-API, partly Java driver
      (D) JDBC-ODBC Bridge plus ODBC driver
      (A) When a connection is created, it is in auto-commit mode.
      (B) If the value is true each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed.
      (C) once auto-commit mode is disabled, no SQL statements will be committed until you call the method commit explicitly
      (D) By default the JDBC call is in auto-commit mode.