1Z0-805 · Question #73
Given this code fragment: try { String query = "SELECT * FROM Item"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(query); ResultSetMetaData rsmd = rs.getMetaData(); int…
Sign in or unlock 1Z0-805 to reveal the answer and full explanation for question #73. The question stem and answer options stay visible for context.
Question
Given this code fragment:
try { String query = "SELECT * FROM Item"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(query); ResultSetMetaData rsmd = rs.getMetaData(); int rowCount = rsmd.getRowCount(); System.out.println ("Processing: " + rowCount + " rows."); while (rs.next()) { // Process each row } } catch (SQLException se) { System.out.println("Error"); } Assume that the SQL query returns records. What is the result?
Options
- ACompilation fails.
- BThe program prints Error
- CAn exception is thrown at runtime
- DThe statement at line 16 execute
Unlock 1Z0-805 to see the answer
You've previewed enough free 1Z0-805 questions. Unlock 1Z0-805 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.