Entire transaction is roll backed without referencing any save points - Oracle Transaction

Q.  What happens when an entire transaction is roll backed without referencing any save points?
- Published on 12 Aug 15

a. All changes are undone made by all of the SQL statements
b. The transaction locks of data is released
c. The transaction ends
d. All of the above

ANSWER: All of the above
 

    Discussion

  • Nirja Shah   -Posted on 22 Sep 15
    - Rolling back means undoing any changes to data that have been performed by SQL statements within an uncommitted transaction.

    - Oracle uses undo tablespaces (or rollback segments) to store old values.

    - The redo log contains a record of changes.

    - Oracle lets you roll back an entire uncommitted transaction.

    - Alternatively, you can roll back the trailing portion of an uncommitted transaction to a marker called a savepoint.

    - In rolling back an entire transaction, without referencing any savepoints, the following occurs:

    1. Oracle undoes all changes made by all the SQL statements in the transaction by using the corresponding undo tablespace.
    2. Oracle releases all the transaction's locks of data.
    3. The transaction ends.

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.)