Answer Happy

Question 3: Assume that A, B, C, D, and E are data items, and that T1, T2, T3, T4, T5, and T6 are transactions. Assume that your DBMS is using shared/exclusive locks for concurrency control. Currently T1 has an exclusive lock on data item A, and T2 has a shared lock on data item C. All Use your knowledge in other data items are currently unlocked. concurrency control to answer the following questions. [around 6 minutes] [3 Marks] Case Answer (a) Consider the operations Read and Write. Which of these can T1 do it to A, given its lock (read, write, neither read nor write, or both read and write)? (b)Consider the operations Read and Write. Which of these can T2 do it to C, given its lock (read, write, neither read nor write, or both read and write)? (c) T3 requests an exclusive lock on D. Will T3 obtain the lock at this point, or will T3 have to wait? (d)T4 requests a shared lock on C. Will T4 obtain the lock at this point, or will T4 have to wait? (e) T5 requests an exclusive lock on C. Will T5 obtain the lock at this point, or will T5 have to wait? (f) T6 requests a shared lock on B. Will T6 obtain the lock at this point, or will T6 have to wait?