What happens when a DELETE statement is executed inside a transaction and then rolled back before commit?
Options
-
A.
Deleted records are restored
-
B.
The entire table is permanently removed
-
C.
The database is automatically dropped
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
Deleted records are restored
Detailed Explanation
- ROLLBACK: Undoes uncommitted changes in a transaction.
- If a transactional DELETE operation is rolled back, the deleted records are restored.
- This behavior depends on transaction support and the storage engine.
