See Description

Name: _________________________________________ Date: __________________

Week 8 – Assignment #8: Chapters Grade: 5% of Class Grade

CH 23: DATABASE RECOVERY TECHNIQUES

23.21 - Suppose that the system crashes before the [read_item, T3, A] entry is written to the log in Figure 23.1 (b); will that make any difference in the recovery process?

23.22 - Suppose that the system crashes before the [write_item, T2, D, 25, 26] entry is written to the log in Figure 23.1 (b); will that make any difference in the recovery process?

23.25 - How does checkpointing in ARIES differ from checkpointing as described in Section 23.1.4?

23.27 - What implications would a no-steal/force buffer management policy have on checkpointing and recovery?

CH 24: DATABASE SECURITY

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 action?