Vidyalelo
Java Programming · Q24

Java Beans and JDBC

Programming · Java Programming · question 24

Q24

Which of the following is NOT a valid method to execute an SQL query in JDBC?

A.
`executeUpdate()`
B.
`execute()`
C.
`executeBatch()`
Answer
D.
`executeQuery()`

Answer: Option C

Solution

Answer: Option C
Solution:
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.