Back to the 2024 paper
Similar questions
Database Management SystemWhich of the following is used to get back all the transactions back after rollback? (i) Commit (ii) Rollback (iii) Flashback (iv) Redo20202mDatabase Management SystemWhich of the following is used for indexing in database systems? (i) Transaction log (ii) B-tree (iii) Views (iv) Triggers20242mDATABASE MANAGEMENT SYSTEMConsider the following ordering schedule — S’ of transactions: `` T1 : R(A); T1 : A := A + 5; T1 : commit; T2 : R(B); T2 : B := B + 5; T3 : R(C); T3 : C := C + 5; T3 : C := C + 5; T4 : R(A); T4 : A := A + 5; T4 : R(D); T4 : D := D + 5; T4 : commit; T2 : commit; T3 : commit; ` Let the initial value of A = B = C = D = 0. The system follows log-based recovery process of *immediate database modification*. The assumption is the concurrency control system uses strict 2PL, and all transactions share a common disk buffer and single log. Explain what happens during the recovery process if a failure occurs at T2 : commit` statement.202114mDatabase Management SystemDiscuss the procedure of deadlock detection and recovery in transaction?20247m