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.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)