Transaction control statements - Commit, Rollback, Savepoint - Oracle Transaction

Q.  Which of the following/s are supported by transaction control statements?
- Published on 04 Aug 15

a. Commit, Rollback, Savepoint
b. Alter,Execute,Drop
c. Insert, Remove, Delete
d. All of the above

ANSWER: Commit, Rollback, Savepoint
 

    Discussion

  • Nirja Shah   -Posted on 22 Sep 15
    - Transaction control statements manage changes made by DML statements. The transaction control statements are:
    COMMIT
    ROLLBACK
    SAVEPOINT
    SET TRANSACTION

    - All transaction control statements, except certain forms of the COMMIT and ROLLBACK commands, are supported in PL/SQL.

    - COMMIT statement - It ends your current transaction and make permanent all changes performed in the transaction. A transaction is a sequence of SQL statements that Oracle Database treats as a single unit. This statement also erases all savepoints in the transaction and releases transaction locks.

    - ROLLBACK statement - It is used to undo work done in the current transaction or to manually undo the work done by an in-doubt distributed transaction.

    - SAVEPOINT statement - It is used to identify a point in a transaction to which you can later roll back.

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