Test Status
      JDBCRANDOMTEST
      (A) Type 1 only
      (B) Type 2 only
      (C) Both Type 3 and Type 4
      (D) All of Type 1, Type 2, Type 3 and Type 4
      (A) Type 1
      (B) Type 2
      (C) Type 3
      (D) Type 4
      (A) TRANSACTION_READ_COMMITTED
      (B) TRANSACTION_READ_UNCOMMITTED
      (C) TRANSACTION_REPEATABLE_READ
      (D) TRANSACTION_SERIALIZABLE
      (A) a
      (B) b
      (C) c
      (D) d
      (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) This problem can be caused by running a JDBC applet in a browser that supports the JDK 1.0.2, such as Netscape Navigator 3.0. The JDK 1.0.2 does not contain the JDBC API, so the DriverManager class typically isn't found by the Java virtual machine running
      (B) Most of the browsers cannot download java.* because of security reasons. Hence many vendors of all-Java JDBC drivers supply versions of the java.sql.* classes that have been renamed to jdbc.sql.*, along with a version of their driver that uses these modify
      (C) Add import jdbc.sql.* in your applet code instead of java.sql.*, and add the jdbc.sql.* classes provided by your JDBC driver vendor to your applet's codebase, then all of the JDBC classes needed by the applet can be downloaded by the browser at run time,
      (D) All of the above
      (A) A workaround is to explicitly call the method DriverManager.registerDriver(new YourDriverClass).
      (B) The problem is due to race condition in the class loader.
      (C) The race condition prevents the static section of code in the driver class from executing and registering the driver with the DriverManager.
      (D) All the above.
      (A) getNumberOfColumn
      (B) getMaxColumn
      (C) getColumnCount
      (D) getColumns
      (A) In the MySQL database mysql
      (B) In the MySQL database metadata
      (C) In the MySQL database metasql
      (D) In the MySQL database mysql
      (A) UNIQUE
      (B) AUTO_INCREMENT
      (C) SEQUENCE
      (D) None of the above -- Surrogate keys are not implemented in MySQL.
      (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) Both Type 1 and Type 2
      (B) Both Type 3 and Type 4
      (C) Both Type 1 and Type 3
      (D) Type 4 only