Bissoy.com
Doctors Medicines MCQs Q&A

A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is

A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is Correct Answer One Safe

The problem with this scheme is that the updates of a committed transaction may not have made it to the backup site, when the backup site takes over processing.

Related Questions

If only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site. This is
A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site. This is
Consider a transaction T1 that committed prior to checkpoint. The record appears in the log before the record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time ____________
We say that a transaction has been ________ when its commit log record has been output to stable storage.
Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and, then apply a 5% interest (i) T1 start (ii) T1 B old = 12000 new = 10000 (ii) T1 M old = 0 new = 2000 (iv) T1 commit (v) T2 start (vi) T2 B old = 10000 new = 10500 (vii) T2 commit Suppose the database system crashed just before log record 7 is written. When the system is restarted, which one statement is true of the recovery procedure?
Which of the following are true statements? I: Primary storage units have faster access time and less storage capacity as compared to the secondary storage units. II: Primary storage units have sequential access. III: Secondary storage units are non-volatile storage.
log 3 + log 9 + log 27 + ……………i. ধারার পরবর্তী পদ log 81 ii. একটি সমান্তর ধারা iii. এর সাধারণ অন্তর log 6 নিচের কোনটি সঠিক?
log 3 + log 9+log 27+...... i. ধারাটির সাধারণ অনুপাত log 3 ii. ধারাটির প্রথম দশটি পদের সমষ্টি 55 log 3 iii. ধারাটি একটি গুণোত্তর ধারা নিচের কোনটি সঠিক?
Consider the following schedule S of transactions T1, T2, T3, T4: T1 T2 T3 T4   Reads(X)         Writes(X) Commit   Writes(X)  Commit         Writes(Y) Reads(Z) Commit           Reads(X) Reads(Y) Commit   Which one of the following statements is CORRECT?
In a certain code language, O is written as R, R is written as A, A is written as I, I is written as N, N is written as E, E is written as P, P is written as T, C is written as M and L is written as L. How will PORCELAIN be written as in that language?