If we define transaction consisting of two SQL statements, crediting John $500 and
debiting Mary $500. Suppose at the beginning of transaction, John has $2000 in his
account, and Mary has $1000 in her account. Suppose an error occurs after crediting John
account but before debiting Mary account, "Rollback" will take place. What will be the
amount in their account after rollback?
Waths the answers
Answers
Answered by
0
Answer:
A transaction is a sequence of operations performed (using one or more SQL statements) on a database as a single logical unit of work. The effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database). A database transaction must be atomic, consistent, isolated and durable. Later we have discussed these four points.
Explanation:
Similar questions