Given the EMPLOYEE table:

EMP_ID | EMP_NAME
-------|---------
100 | Tom
101 | Mary
102 | Peter
103 | Robin

Given the code fragment:

try (Connection con = DriverManager.getConnection (dbURL, user, passwd)); {
Statement stmt = con.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery ("SELECT * FROM employees");

rs.absolute (3); // Line1
rs.moveToInsertRow();
rs.updateInt(1, 104);
rs.updateString(2, "Michael");
rs.insertRow();
rs.moveToCurrentRow();
System.out.println ("Employee Id: " + rs.getInt(1) + ", Employee Name: " +
rs.getString(2));
}

Assuming the database supports scrolling and updating, what is the result?

Question

Given the EMPLOYEE table:

EMP_ID | EMP_NAME
-------|---------
100 | Tom
101 | Mary
102 | Peter
103 | Robin

Given the code fragment:

try (Connection con = DriverManager.getConnection (dbURL, user, passwd)); {
 Statement stmt = con.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,
 ResultSet.CONCUR_UPDATABLE);
 ResultSet rs = stmt.executeQuery ("SELECT * FROM employees");

rs.absolute (3); // Line1
 rs.moveToInsertRow();
 rs.updateInt(1, 104);
 rs.updateString(2, "Michael");
 rs.insertRow();
 rs.moveToCurrentRow();
 System.out.println ("Employee Id: " + rs.getInt(1) + ", Employee Name: " +
 rs.getString(2));
}

Assuming the database supports scrolling and updating, what is the result?

Accepted Answer

C. A new record is inserted and Employee id: 102, Employee Name: Peter is displayed.

Answer

A. The program throws a runtime exception at Line 1.

Answer

B. A compilation error occurs.

Answer

D. A new record is inserted and Employee id: 104, Employee Name: Michael is displayed.

Given the EMPLOYEE table: EMP_ID | EMP_NAME -------|--------- 100 | Tom 101 | Mary 102 | Peter 103 | Robin Given the code fragment: try (Connection con = DriverManager.getConnection (dbURL, user…

Question

Options

How the community answered

Explanation

Community Discussion