ExamVeda
Login
Home
This question belongs to Java Program Java Beans And JDBC
Java Beans and JDBC
?

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 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.
Examveda
Question posted by Examveda
Community

Join the Discussion

1 Comment
CHANDRAPRAKASH PRAJAPAT
CHANDRAPRAKASH PRAJAPAT 2 years ago

The 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().