118k views
2 votes
The ___ state corresponds to the transaction leaving the system. The transaction information that is maintained in system tables while the transaction has been running is removed when the transaction terminates.

1 Answer

5 votes

Final answer:

The word that fills the blank is 'committed,' indicating the completion and exit of the transaction from the system, while the temporary transaction information is removed.

Step-by-step explanation:

The blank in the statement should be filled with the word 'committed.' When a transaction in a database management system reaches its end, the committed state corresponds to the transaction leaving the system. At this point, the transaction is complete, and all of its operations are permanently recorded in the database. The transaction information that had been temporarily stored in system tables while the transaction was active is now removed as the transaction has been successfully committed and is no longer needed for recovery or rollback purposes.

User Gizella
by
7.4k points