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

Options
- Partially committed
- Committed
- Aborted
- Failed


CORRECT ANSWER : Aborted

Discussion Board
Aborted

A transaction state changes from active to abortes, after the transaction has been rolled back and the database restored to its state prior to the start of the transaction. There are two options after transaction has been aborted:
1. Restart the transaction: Only if no internal logical error but hardware or software failure.
2. Kill the transaction: Once the internal logical error occurs like incorrect data input.

Prajakta Pandit 03-15-2017 05:48 AM

Write your comments

 
   
 
 

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


Advertisement