JDBC

Question 1

Which object has all capabilities of a WebRowSet object, in addition to SQL JOIN capabilities?

Answer 1

JoinRowSet

Question 2

Which method was used to load database drivers before establishing a connection when using a JDBC version previous to JDBC 4?

Answer 2

Class.forName()

Question 3

Which concurrency option indicates that a result set should support updates?

Answer 3

CONCUR_UPDATABLE

Question 4

Which ResultSet method moves the cursor forward one row?

Answer 4

next

Question 5

Which transaction isolation level option allows dirty, non-repeatable, and phantom reads?

Answer 5

TRANSACTION_READ_UNCOMMITTED

Defined in Connection.

Question 6

Which two standards must a database driver support to meet JDBC compliance?

Answer 6

JDBC API and SQL 92 Entry Level

Question 7

Which resultSetType option indicates ResultSet object that is scrollable and generally sensitive to underlying changes to the data.

Answer 7

TYPE_SCROLL_SENSITIVE

Defined in ResultSet

Question 8

Which transaction isolation level prevents dirty, non-repeatable, and phantom reads?

Answer 8

TRANSACTION_SERIALIZABLE

Defined in Connection.

Question 9

Which transaction isolation level indicates that dirty reads and non-repeatable reads are prevented; phantom reads can occur?

Answer 9

TRANSACTION_REPEATABLE_READ

Defined in Connection.

Question 10

Which transaction isolation level indicates that dirty reads are prevented; non-repeatable reads and phantom reads can occur.

Answer 10

TRANSACTION_READ_COMMITTED

Defined in Connection.

Question 11

Which resultSetType option indicates ResultSet object that is scrollable but generally not sensitive to changes to the underlying data.

Answer 11

TYPE_SCROLL_INSENSITIVE

Defined in ResultSet.

Question 12

Which resultSetType option indicates ResultSet object whose cursor may move only forward.

Answer 12

TYPE_FORWARD_ONLY

Defined in ResultSet.

Question 13

Which isolation level applies an exclusive read/write lock for a query and only releases it after the transaction commits?

Answer 13

TRANSACTION_SERIALIZABLE

Question 14

What is the connection string syntax for the Java DB Embedded Driver?

Answer 14

jdbc:derby:databaseName

Question 15

Which object has all capabilities of a WebRowSet object, in addition to support for custom filters?

Answer 15

FilteredRowSet

Question 16

Which three methods of the RowSetFactory create a RowSet object that supports XML read/write operations?

Answer 16

createFilteredRowSet, createJoinRowSet, and createWebRowSet

Question 17

Which Statement method should be invoked to execute SELECT queries?

Answer 17

executeQuery

Question 18

How does JDBC 4 differ from previous versions when it establishes a database connection?

Answer 18

JDBC 4 automatically loads suitable drivers based on the database connection URL

Question 19

Which two fields will create a scrollable ResultSet object?

Answer 19

TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE

Question 20

Which object is a connected interface that provides a JavaBean view of a result set?

Answer 20

JdbcRowSet

Question 21

Which Statement method should be invoked to execute DML statement?

Answer 21

executeUpdate

Question 22

How do you establish a connection using using JDBC 4 drivers?

Answer 22

DriverManager.getConnection() and DataSource.getConnection()

Question 23

When is a Connection object closed if it is declared in a try-with-resources statement?

Answer 23

After the try block runs

Question 24

What is a phantom read?

Answer 24

(Phantom reads) The situation that occurs when a transaction reads data it has previously read and finds new rows that were inserted by a committed transaction.

Question 25

What is a dirty read?

Answer 25

A dirty read is when a value is read from the database that has not yet been committed. T1 writes value X; T2 reads value X; Since X is not committed, X is considered “dirty”;

Question 26

What is a non-repeatable read?

Answer 26

A non-repeatable read occurs, when during the course of a transaction, a row is retrieved twice and the values within the row differ between reads.

Question 27

Which class is the default implementation of the connected interface that provides a JavaBean view of a result set?

Answer 27

JdbcRowSetImp

Question 28

Which two classes are used to create a connected RowSet object in Java 7?

Answer 28

RowSetProvider and RowSetFactory

Question 29

Which isolation level applies an exclusive write lock for a query and only releases it after the transaction commits?

Answer 29

TRANSACTION_REPEATABLE_READ

Question 30

Which Statement method should be invoked to execute UPDATE, INSERT, and DELETE queries?

Answer 30

executeUpdate

Question 31

Which isolation level prevents dirty and non-repeatable reads, but allows phantom reads?

Answer 31

TRANSACTION_REPEATABLE_READ

Question 32

Which isolation level does not use a shared or exclusive locking mechanism?

Answer 32

TRANSACTION_READ_UNCOMMITTED

Question 33

When auto-commit mode is disabled, which action actually executes SQL statements?

Answer 33

Invoking the commit method.

Question 34

Which ResultSet method should be invoked before accessing the first row?

Answer 34

next

Question 35

Which Statement class represents a query that is compiled on the DBMS immediately, so that subsequent statements are executed without recompiling?

Answer 35

PreparedStatement

Question 36

Which Statement class represents a stored procedure that is compiled on the DBMS?

Answer 36

CallableStatement

Question 37

Which parameter type(s) are supported by a PreparedStatement object?

Answer 37

Input parameters only

Question 38

What is the local connection string syntax for the Java DB Network Client Driv

Answer 38

jdbc:derby://localhost:port/databaseName

Question 39

Which isolation level uses a shared locking mechanism that only prevents access to uncommitted values?

Answer 39

TRANSACTION_READ_COMMITTED

Question 40

Which two fields are the default values for a ResultSet object? I.E. default concurrency level and ResultSet type.

Answer 40

CONCUR_READ_ONLY and TYPE_FORWARD_ONLY

Question 41

Is Savepoint an Interface, Abstract class, or Concrete class

Answer 41

Interface