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