Given the information: Emp table has 10 records.
Given the code fragment:

try (Connection con = DriverManager.getConnection ("Connection_String")); {
Statement stmt = con.createStatement (ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery ("SELECT * FROM EMP"); {
// Line n1
}

Which code fragment, inserted at Line n1, helps you determine the number of records in ResultSet?

Question

Given the information: Emp table has 10 records.
Given the code fragment:

try (Connection con = DriverManager.getConnection ("Connection_String")); {
 Statement stmt = con.createStatement (ResultSet.TYPE_FORWARD_ONLY,
 ResultSet.CONCUR_READ_ONLY);
 ResultSet rs = stmt.executeQuery ("SELECT * FROM EMP"); {
 // Line n1
}

Which code fragment, inserted at Line n1, helps you determine the number of records in ResultSet?

Accepted Answer

B. int totRows=0; while(rs.next()) {totRows++;}

Answer

A. rs.getMetaData().getRowCount();

Answer

C. rs.last(); int totRows = rs.getRowCount();

Answer

D. rs.last(); int totRows = rs.getRowId(1);

Given the information: Emp table has 10 records. Given the code fragment: try (Connection con = DriverManager.getConnection ("Connection_String")); { Statement stmt = con.createStatement…

Question

Options

How the community answered

Explanation

Community Discussion