Test Status
      JDBCRANDOMTEST
      (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
      (B) Type 3
      (C) Type 2
      (D) Type 1
      (A) TRANSACTION_READ_ COMMITTED
      (B) TRANSACTION_UNREAD_ COMMITTED
      (A) Type 1
      (B) Type 2
      (C) Type 3
      (D) Type 4
      (A) UNIQUE
      (B) AUTO_INCREMENT
      (C) SEQUENCE
      (D) None of the above -- Surrogate keys are not implemented in MySQL.
      (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
      (A) Both types of result sets will make changes visible if they are closed and then reopened.
      (B) A result set that is TYPE_SCROLL_INSENSITIVE does not reflect changes made while it is still open and one that is TYPE_SCROLL_SENSITIVE does.
      (C) You will get a scrollable ResultSet object if you specify one of these ResultSet constants.
      (D) A result set that is TYPE_SCROLL_INSENSITIVE makes the result set read only while one that is TYPE_SCROLL_SENSITIVE does not.
      (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.
      (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) a
      (B) b
      (C) c
      (D) d
      (A) Regular Statement
      (B) Interim Statement
      (C) Callable Statement
      (D) Prepared Statement
      (A) registerDriver() method
      (B) Class.forName()
      (C) Both A and B
      (D) getConnection()