Pass the Oracle Java SE 1z0-809 Questions and answers with ExamsMirror

Given:

What is the result?

Given the records from the Employee table:

and given the code fragment:

try {

Connection conn = DriverManager.getConnection (URL, userName, passWord);

Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

ResultSet.CONCUR_UPDATABLE);

st.execute(“SELECT*FROM Employee”);

ResultSet rs = st.getResultSet();

while (rs.next()) {

if (rs.getInt(1) ==112) {

rs.updateString(2, “Jack”);

}

}

rs.absolute(2);

System.out.println(rs.getInt(1) + “ “ + rs.getString(2));

} catch (SQLException ex) {

System.out.println(“Exception is raised”);

}

Assume that:

The required database driver is configured in the classpath.

The appropriate database accessible with the URL, userName, and passWord exists.

What is the result?