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.
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"
Entire Web pages can be saved to your hard drive and viewed while you are offline
Indicate whether the statement is true or false
To see the relationship between two numeric variables, you would use a scatter chart
Indicate whether the statement is true or false
Fingerprint and face recognition scanners are examples of biometric locks.
What will be an ideal response?