Subroutines can be used in a flat transaction in an attempt to mimic the behavior of a subtransaction in the nested model: whenever a subtransaction aborts, the corresponding subroutine manually undoes any database updates it has performed and returns with status indicating failure. Explain why the nested model allows higher transaction throughput.
What will be an ideal response?
When a subtransaction aborts, any newlocks it has obtained are released. Newlocks
obtained by the subroutine, however, are not released.
You might also like to view...
Rewrite exercise 15 to call the function with a random number between 0 and 10 inclusive. (Hint: The randint function in the random library returns a random number between its two arguments inclusive.)
What will be an ideal response?
The value of s[s[6] - s[5]] is:
Consider the array: ``` s[0] = 7 s[1] = 0 s[2] = -12 s[3] = 9 s[4] = 10 s[5] = 3 s[6] = 6 ``` a. 0. b. 3. c. 9. d. 10.
Which of the following categories of computers has the largest relative size and capacity?
A) tablet computer B) laptop C) desktop computer D) smartphone
Which of the following would make a good primary key?
A. AutoNumber data type B. Customer name C. Number data type D. Birthday