?
Which of the following is NOT a valid method to execute an SQL query in JDBC?
Answer & Solution
Correct Answer:
Option
C
executeUpdate(): This method is used to execute SQL statements that update the database, such as
execute(): This method can be used to execute any SQL statement, and it returns a boolean. The returned value is
executeBatch(): This method is used to execute a batch of SQL statements. It sends multiple SQL statements to the database for execution as a batch and returns an array of update counts. It is not used to execute a single SQL query.
executeQuery(): This method is used to execute SQL queries that retrieve data from the database, such as
Therefore, executeBatch() is not a valid method to execute a single SQL query in JDBC.
INSERT, UPDATE, or DELETE statements. It returns an integer representing the number of rows affected by the query.execute(): This method can be used to execute any SQL statement, and it returns a boolean. The returned value is
true if the result is a ResultSet object; otherwise, it returns false.executeBatch(): This method is used to execute a batch of SQL statements. It sends multiple SQL statements to the database for execution as a batch and returns an array of update counts. It is not used to execute a single SQL query.
executeQuery(): This method is used to execute SQL queries that retrieve data from the database, such as
SELECT statements. It returns a ResultSet object containing the data produced by the query.Therefore, executeBatch() is not a valid method to execute a single SQL query in JDBC.
Join the Discussion
Login to post a comment or share your explanation.
LoginThe method executeBatch() is not typically used to execute SQL queries in JDBC; instead, it is used to execute batches of SQL statements. So, the answer is C. executeBatch().