Transaction state changes from active to aborted - Database

Q.  A transaction state changes from active to______, after the transaction has been rolled back and the database restored to its state prior to the start of the transaction.
- Published on 19 Oct 15

a. Partially committed
b. Committed
c. Aborted
d. Failed

ANSWER: Aborted
 

    Discussion

  • Nirja Shah   -Posted on 30 Oct 15
    There are different transaction state:
    Active
    - This is the initial state.
    - The transaction stays in this state while it is executing.

    Partially committed
    - We come in this state after the final statement has been executed.

    Failed
    - This state occurs after the discovery that normal execution can no longer proceed.

    Aborted
    - After the transaction is rolled back and the database restored to its state prior to the start of the transaction.
    - There are two options after it has been aborted:

    Restart the transaction - Only if no internal logical error but hardware or software failure.

    Kill the transaction - Once the internal logical error occurs like incorrect data input.

    Committed
    - It happens after the successful completion.
    - The transaction is terminated once it is aborted or committed.

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