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

The default setting for a hanging indent is ________

A) 0.5" B) 1" C) 1.5" D) 2.0"

Computer Science & Information Technology

Entire Web pages can be saved to your hard drive and viewed while you are offline

Indicate whether the statement is true or false

Computer Science & Information Technology

To see the relationship between two numeric variables, you would use a scatter chart

Indicate whether the statement is true or false

Computer Science & Information Technology

Fingerprint and face recognition scanners are examples of biometric locks.

What will be an ideal response?

Computer Science & Information Technology