Explain why executions are always strict even if read locks are released after the last operation of a transaction but before its commitment. Give an improved statement of Rule 2
What will be an ideal response?
Strict executions require that read and write operations on a data item are delayed until all transactions that previously wrote that data item have either committed or aborted. The holding of a write lock is sufficient to protect future transactions from non-strictness because we are concerned only with previous write operations.
Rule 2: When the client indicates that the last operation has been done (by a request to commit or abort), release read locks. Hold write locks until commit or abort is completed.
You might also like to view...
This is a routing algorithm that periodically sends the entire routing table to its neighboring or adjacent router.
What will be an ideal response?
Identify the letter of the choice that best matches the phrase or definition.
A. Allows the user to enter data into text blocks B. Enable user to enter text that is then stored as variable C. Approximately 1000 bytes D. Statement used to assign a value to a variable E. Equivalent to one character of information F. User-defined object that holds data and whose value can change G. As the file downloads, the initial file can start playing H. Specify what type of data a variable can contain I. Compares one value with another J. An example is = = K. Cannot be changed after the document plays in Flash Player L. Assures visitors that the Web site is loading
Which of the following risks relates to negative public opinion?
A. Operational risk B. Strategic risk C. Financial risk D. Reputational risk
An operator that associates from right to left is
a) != b) , c) () d) ?: