SQL for Java Devs · interview question

Consider the following code snippet. What will be the result if executeBatch() is called and one of the SQL statements is invalid?

Multiple choiceMediumchapter-8-curatedpremiumsql-for-java-devsbatching

java

PreparedStatement ps = conn.prepareStatement(sql);
ps.addBatch();
// add more batches
ps.executeBatch();

All statements in the batch will be rolled back.Only the invalid statement will be skipped, others will execute.The transaction will continue but log an error for the invalid statement.The batch will execute up to the invalid statement, then stop.

Answer and explanation

Correct answer

A. All statements in the batch will be rolled back.

Why

If one of the statements is invalid and executeBatch() is called, the entire batch will be rolled back unless error handling and transaction management are explicitly implemented to handle partial successes.

Test yourself on SQL for Java Devs

A free test with instant, explained results. No account needed.

Start free test

All SQL for Java Devs questions →

Consider the following code snippet. What will be the result if executeBatch() is called and one of the SQL statements is invalid?

Correct answer

Why

More SQL for Java Devs questions