You have the following code of a PreparedStatement.

GIAC GSSP-Java Question Answer

PreparedStatement stm = con.prepareStatement("UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?");

Which of the following statements are true about a PreparedStatement?

Each correct answer represents a complete solution. Choose all that apply.

The executeUpdate() method executes the SQL query in the PreparedStatement object and returns the ResultSet object generated by the query.

A PreparedStatement reduces execution time if it is required to execute the SQL statementmultiple times.

When the executeQuery() method is used to execute a DDL statement, such as in creating a table, it returns the int 0.

It is illegal for an instance of a PreparedStatement to contain a SQL statement that has already been compiled.

GIAC GSSP-Java Summary

Price: $52.5 ~~$149.99~~