What is wrong with the following statement? ResultSet result = statement.execute("SELECT * from emp WHERE empNum = '5'");
A) ResultSet should be String
B) execute should be executeQuery
C) execute should be prepareStatement
D) 5 should not be used as an empNum value

Question

Quizplus · Accepted Answer

The `execute` method is used for executing SQL statements that may return multiple results, while `executeQuery` is specifically used for executing SQL statements that return a single `ResultSet`, such as a `SELECT` query.

What Is Wrong with the Following Statement? ResultSet Result =