ROLLBACK statement is issued to database transaction has ended - Fundamentals of PL/SQL
Q. Which of the following results are true, when a ROLLBACK statement is issued to the database, the transaction has ended?- Published on 07 Jul 15
a. All work done by the transaction is undone, as if it hadn't been issued.
b. Any locks acquired by the transaction are released.
c. Both A & B
d. None of the above
ANSWER: Both A & B
The undoing of all or some of the changes in a database during the current transaction is known as ROLLBACK. This statement is embedded as static SQL.