Explain why transaction management is necessary in systems where user inputs can result in database changes.
What will be an ideal response?
A transaction mechanism is necessary to ensure database consistency. As a
transaction is an atomic operation, all of the changes in the transaction are not
committed until it is complete. If these changes were made in sequence without a
transaction mechanism, a system failure could mean that the update of the database
was unfinished and the data left in an inconsistent state.
Computer Science & Information Technology
You might also like to view...
How do you quickly select a sentence?
A) Double-click anywhere in the sentence B) Hold down Ctrl and click in the sentence C) Hold down Shift and click in the sentence D) Triple-click anywhere in the sentence
Computer Science & Information Technology
Word color themes can be modified and saved with a new name
Indicate whether the statement is true or false
Computer Science & Information Technology