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 SystemWhich of the following ensures no data is lost after a system crash? (i) Commit log (ii) View (iii) Recovery manager (iv) Trigger20242m
PreviousA B-tree of order 4 and of height 3 will have a maximum of ____ keys. (i) 255 (ii) 63 (iii) 127 (iv) 188NextWhich of the following is used to get back all the transactions back after rollback? (i) Commit (ii) Rollback (iii) Flashback (iv) Redo
AI LearningWeb Platform
Coursify — Personal AI Course Generator
Struggling with a difficult subject or concept? Turn any engineering topic into a structured course with interactive lessons, quizzes, and research-backed explanations.