1Z0-819 JDBC 2

Question 1

Which method of `PreparedStatement` is used to execute a SQL INSERT and return the number of affected rows?

Accepted Answer

executeUpdate()

Answer

`executeUpdate()` executes DML statements (INSERT, UPDATE, DELETE) and returns the count of affected rows.

Question 2

What does `Connection.setAutoCommit(false)` do in JDBC?

Accepted Answer

Begins a manual transaction requiring explicit commit or rollback

Answer

Setting autoCommit to false puts the connection into manual transaction mode where you must call `commit()` or `rollback()` explicitly.

Question 3

Which `ResultSet` method moves the cursor to the next row and returns `false` when no more rows exist?

Accepted Answer

next()

Answer

`ResultSet.next()` advances the cursor one row forward and returns `false` when there are no more rows.

Question 4

What exception is thrown by JDBC methods when a database access error occurs?

Accepted Answer

SQLException

Answer

`SQLException` is the checked exception thrown by virtually all JDBC API methods when a database or driver error occurs.

Question 5

Which `DriverManager` method is used to obtain a database `Connection`?

Accepted Answer

DriverManager.getConnection(url, user, pass)

Answer

`DriverManager.getConnection(url, user, password)` is the standard JDBC entry point for obtaining a database connection.

(1Z0-819) Oracle Java SE 11 Developer Practice Test