Which JDBC object represents a set of rows returned by a query?

Which JDBC object represents a set of rows returned by a query?

• A. Statement
• B. Connection
• C. DriverManager
• D. ResultSet

Answer: (D)

In JDBC, the data produced by a SELECT query is encapsulated in a ResultSet. This object represents the set of rows returned by the query and provides a cursor to move through them row by row, letting you read each column’s value with methods like getInt, getString, and so on. A ResultSet is created when you execute a query via a Statement or PreparedStatement, and you typically loop over it with next() to access every row. The other objects have different roles: a Statement is used to send SQL commands to the database (it doesn’t hold the data itself), a Connection represents the active link to the database session, and DriverManager is a utility that helps you obtain connections by loading the appropriate JDBC driver.

In JDBC, the data produced by a SELECT query is encapsulated in a ResultSet. This object represents the set of rows returned by the query and provides a cursor to move through them row by row, letting you read each column’s value with methods like getInt, getString, and so on. A ResultSet is created when you execute a query via a Statement or PreparedStatement, and you typically loop over it with next() to access every row.

The other objects have different roles: a Statement is used to send SQL commands to the database (it doesn’t hold the data itself), a Connection represents the active link to the database session, and DriverManager is a utility that helps you obtain connections by loading the appropriate JDBC driver.