Multiple choice technology

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

Transactions require auto-commit to be disabled BEFORE starting transactional operations. This allows multiple statements to be grouped together and either committed (all succeed) or rolled back (all fail) as a unit. Option C is false because auto-commit must be turned off before, not after, the transaction begins.

Keep practicing — related questions