1Z0-819 JDBC 5

Question 1

Which `ResultSet` method retrieves the value of a column as a `java.sql.Timestamp`?

Accepted Answer

getTimestamp(columnLabel)

Answer

`ResultSet.getTimestamp(columnLabel)` retrieves a column value as a `java.sql.Timestamp`, which represents both date and time with nanosecond precision.

Question 2

What does `ResultSet.wasNull()` return after calling a getter like `getInt()`?

Accepted Answer

true if the last column read contained a SQL NULL value

Answer

`wasNull()` returns `true` if the last column value read via any getter was SQL NULL, since primitive getters like `getInt()` return 0 for NULL and you need this method to distinguish.

Question 3

Which approach correctly loads a JDBC driver in Java 11 without explicitly calling `Class.forName()`?

Accepted Answer

The ServiceLoader mechanism automatically discovers drivers on the classpath via META-INF/services

Answer

Since JDBC 4.0 (Java 6+), drivers on the classpath are auto-loaded via the `ServiceLoader` mechanism using `META-INF/services/java.sql.Driver`, eliminating the need for `Class.forName()`.

Question 4

Which method on `CallableStatement` registers an OUT parameter before executing a stored procedure?

Accepted Answer

registerOutParameter(index, sqlType)

Answer

`CallableStatement.registerOutParameter(index, sqlType)` must be called before execution to tell JDBC the type of each OUT parameter to be retrieved afterward.

Question 5

What SQL syntax is used in JDBC to call a stored procedure with one IN and one OUT parameter?

Accepted Answer

"{call myProc(?, ?)}"

Answer

JDBC uses the escape syntax `{call procedureName(?, ?)}` to call stored procedures in a portable, database-independent way.

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

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

1Z0-819 JDBC 5