Multiple choice technology architecture

Which of the following is false wrt Transactions ?

  1. A transaction is a set of sql statements

  2. Auto commit to be set off before Transaction

  3. Auto commit to be set off after transaction

  4. Commit permanently records to database all changes waiting with current Connection

  5. Rollback is used in case of any error to undo transaction
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To manage transactions manually in JDBC, auto-commit must be set to false before running transaction statements. The assertion that auto-commit must be turned off after the transaction is false, as by that point the individual operations would have already committed automatically.

Keep practicing — related questions