Transaction scope is where you need to update multiple database records t o complete a business process. For example. Debit my bank account, credit yours. Either both should succeed (commit) or both should fail (rollback). Locking describes what can happen to records whilst they are being written to or read. Should you be able to read the balance off my account if another process is currently updating the balance figure. Does the decision change if it is updating something else like the overdraft credit limit?
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
What are
transaction scope
anddatabase locking and database normalisation
?Transaction scope is where you need to update multiple database records t o complete a business process. For example. Debit my bank account, credit yours. Either both should succeed (commit) or both should fail (rollback). Locking describes what can happen to records whilst they are being written to or read. Should you be able to read the balance off my account if another process is currently updating the balance figure. Does the decision change if it is updating something else like the overdraft credit limit?