Home » MCQs » HSQLDB MCQs

If the transaction fails, the ____ command should be used to restore the prior state of all tables referenced in the transaction?

34. If the transaction fails, the ____ command should be used to restore the prior state of all tables referenced in the transaction?

1. COMMIT
2. ROLLBACK
3. SAVEPOINT

Answer: B) ROLLBACK

Explanation:

If the transaction fails, the ROLLBACK command should be used to restore the prior state of all tables referenced in the transaction.