ACID properties Which ACID properties are illustrated by the following transactions? (a) While a new row is
Question:
ACID properties Which ACID properties are illustrated by the following transactions?
(a) While a new row is being added to a table by one process, another process reads the entire table but the new row is not included.
(b) While a new row is being added to a table by one process, the process is interrupted and the transaction does not complete within a specified time-out period. The transaction is rolled back.
(c) A disk crash wipes out one copy of a database. Transactions are routed to a back-up location.
(d) A data aging process inspects the date at which data were entered and removes them if a lifetime tag associated with the data is exceeded.
(e) A complicated transaction is broken into a series of actions so that if one action is interrupted, the series can restart at that point of interruption.
However, other processes see no change to the database until the entire transaction is complete.
(f) A transaction requires intermediate quantities to be stored, which are deleted at the completion of the transaction.
Step by Step Answer:
Principles Of Embedded Networked Systems Design
ISBN: 978-0521095235
1st Edition
Authors: Gregory J. Pottie ,William J. Kaiser