202 views

1 Answer

0 votes
0 votes
ROLLBACK is a  command that execute at the end of current transaction and undo/undone any changes made since the begin transaction.

but Aborting means a transaction that consists of ensuring that state of the database becomes as if the transaction had never begun. Any changes made by the transaction must be undone and we must ensure that those changes had no effect on any concurrently executing transactions. during this stage we can kill any process/transcation which is not used for longer time.

Related questions

0 votes
0 votes
0 answers
1
Arnabi asked Jan 17, 2017
158 views
Do prime attributes need to appear in all candidate keys?
0 votes
0 votes
0 answers
2
Shivani gaikawad asked Oct 27, 2018
211 views
i am getting 10 please check it answer is 12
1 votes
1 votes
2 answers
3
Shivani gaikawad asked Oct 27, 2018
408 views
6 votes
6 votes
1 answer
4
Habibkhan asked Oct 19, 2016
1,077 views
Q : One basic doubt that is coming to my mind is whether number of splits in the process of insertion in B+ Tree indexing going to change if we consider left biasing and ...