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


Related Content

Advertisement
 
▲