Machine-translated by Google. Questions are authored in English.
Top

Discussion

A transaction is in the ______ state after its final statement has been executed and its changes have been written to the database.

  • A.partially committed
  • B.active
  • C.committed
  • D.none of the above

Answer: C

Correct answer: committed

A transaction becomes partially committed when its last statement has executed but its changes are not yet certain to survive; it becomes committed once they have been written durably. The distinction is what makes recovery possible.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.