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?
- COMMIT
- ROLLBACK
- 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.