Given the records from the Employee table:

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?

Question

Given the records from the Employee table:

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?

Exam-Answer · Accepted Answer

The Employee table is not updated and the program prints: 112 Jerry

Question 71 of 130 from exam 1Z0-809: Java SE 8 Programmer II

Question

Answers

Explanations