Bissoy.com
Doctors Medicines MCQs Q&A

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

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 Correct Answer Two Safe

This scheme provides better availability than does two-very-safe, while avoiding the problem of lost transactions faced by the one-safe scheme.

Related Questions

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 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.
You are the administrator of a Windows 2000 Server computer named Intra. Intra is a member of an Active Directory domain and hosts an Intranet Web-Ske for your company. Company policy requires that only authenticated users have access to the intranet site. All company users have a user account in the Active Directory domain. You configure directory security for the Web Site to use integrated security. However, you discover that users can access the Web Site without authentication. You need to ensure that only authenticated users can access the web site. What should you do?
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. ধারাটি একটি গুণোত্তর ধারা নিচের কোনটি সঠিক?
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?