Register

Databases commit and rollback

320 views
0 votes
0 votes
In order to undo the work of transaction after last commit which one should be used?
(A) View (B) Commit
(C) Rollback (D) Flashback
User Avatar

1 Answer

0 votes
0 votes

@jaimin19

(C) Rollback ....

Rollback work causes the current transaction to be rolled back; that is, it undoes all the updates performed by the SQL statements in the transaction....

User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
Tara33 asked Dec 25, 2022
265 views
Casecading rollback in WD and WW
Is the possibility of cascading rollbacks more in Wound and Wait or in Wait Die?
Is the possibility of cascading rollbacks more in Wound and Wait or in Wait Die?
User Avatar
3 votes
3 votes
1 answer
2
Saikat asked Nov 5, 2015
3,773 views
Can anyone please help me with that UNDO and REDO concept in recovery of transaction with commit and checkpoint?
User Avatar
0 votes
0 votes
0 answers
3
pCS asked Dec 9, 2017
203 views
Effect of rollback on timestamp
If RTS('A') is set to transaction T's timestamp but then T has to rollback. Then what will RTS('A') be a)0 b)remains same c)equals timestamp of a transaction (if any) which had read 'A' before T.
If RTS('A') is set to transaction T's timestamp but then T has to rollback. Then what will RTS('A') bea)0b)remains samec)equals timestamp of a transaction (if any) which ...
User Avatar
Link Copied!