Assignment #3 Example | Topics and Well Written Essays - 500 words

#3 - Assignment Example Discuss the final result of the different schedules in Figure 21.3 (a) and (b), where M = 2 and N = 2, with respect to the following questions. Does adding the above condition change the final outcome? Does the outcome obey the implied consistency rule (that the capacity of X is 90)? However, a transaction could end in two ways, When it â€Å"Commits† that is all changes to the database are registered or â€Å"Rollback† when the chances are ignored and database returns to original state. With ARIES, main memory buffers that have been modified are not flushed to disk. ARIES, however writes additional information to the LOG in the form of a Transaction Table and a Dirty Page Table when a checkpoint occurs. No-steal means that the cache (buffer) page updated by a transaction cannot be written to disk before the transaction commits. Force means that updated pages are written to disk when a transaction commits. 24.33  - Suppose that privilege (a) of exercise 24.32 is to be given with GRANT OPTION but only so that account A can grant it to at most five accounts, and each of these accounts can propagate the privilege to other accounts but without the GRANT OPTION privilege. What would the horizontal and vertical propagation limits be in this case? 24.34  - Consider the relation shown in Figure 24.2 (d). How would it appear to a user with classification U? Suppose a classification U user tries to update the salary of "Smith" to $50,000; what would be the result of this