[solved] – Question 76510

What would happen if a ROLLBACK is executed after an INSERT statement within a transaction?

The ROLLBACK fails because it is only for UPDATE

Records from the table are deleted

The record(s) that were inserted do not get committed to the table

The records are left inconsistent

Expert Answer

---