Back to the 2020 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 SYSTEMTransaction processing is associated with everything below, except - (i) conforming an action or triggering a response (ii) producing detailed summary or exception report (iii) recording a business activity (iv) maintaining a data20212mDATABASE 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 SystemIn ACID properties, which component ensures that once a transaction is committed, it remains so? (i) Atomicity (ii) Durability (iii) Isolation (iv) Consistency20242m