Given the code fragment:

try { String query = "SELECT * FROM Employee WHERE ID=110"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(query); // Line 13 System.out.println("Employee ID: " + rs.getInt("ID")); // Line 14 } catch (Exception se) { System.out.println("Error"); } Assume that the SQL query matches one record. What is the result of compiling and executing this code?

Question

Given the code fragment:

try { String query = "SELECT * FROM Employee WHERE ID=110"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(query); // Line 13 System.out.println("Employee ID: " + rs.getInt("ID")); // Line 14 } catch (Exception se) { System.out.println("Error"); } Assume that the SQL query matches one record. What is the result of compiling and executing this code?

Accepted Answer

B. The code prints the employee ID.

Answer

A. The code prints error.

Answer

C. Compilation fails due to an error at line 13.

Answer

D. Compilation fails due to an error at line 14.

Given the code fragment: try { String query = "SELECT * FROM Employee WHERE ID=110"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(query); // Line 13…

Question

Options

How the community answered

Community Discussion