Bissoy.com
Doctors Medicines MCQs Q&A

________ allows only committed data to be read and further requires that no other transaction is allowed to update it between two reads of a data item by a transaction.

________ allows only committed data to be read and further requires that no other transaction is allowed to update it between two reads of a data item by a transaction. Correct Answer Repeatable read

Repeatable read allows only committed data to be read and further requires that no other transaction is allowed to update it between two reads of a data item by a transaction. However, the transaction may not be serializable with respect to other transactions.

Related Questions

Four engineers, designated as CE, SE, EE and AE, read a certain number of newspapers early in the morning. One of them reads four newspapers, another reads three newspapers, the third reads two newspapers while the fourth one reads one newspaper. Below are some additional facts regarding the names of these officers. a) N is not the EE b) H is the AE c) N is not the CE and he reads more number of newspapers than L d) The one who is the CE reads more number of newspapers than L e) The person who is the SE reads the maximum number of newspapers f) B does not read two newspapers Which of the following statements is necessarily true?
Consider the following partial Schedule S involving two transactions T1 and T2. Only the read and the write operations have been shown. The read operation on data item P is denoted by read(P) and the write operation on data item P is denoted by write(P) Time Instance Transaction-id T1 T2 1 read(A)   2 write(A)   3   read(C) 4   write(C) 5   read(B) 6   write(B) 7   read(A) 8   Commit 9 read(B)     Schedule S   Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?
Two newspapers A and B are published in a city. It is known that 25% of the city population reads A and 20% reads B while 8% reads both A and B. Further, 30% of those who read A but not B look into advertisements and 40% of those who read B but not A also look into advertisements, while 50% of those who read both A and B look into advertisements. Then the percentage of the population who look into advertisements is:
In Bengaluru, only two newspapers The Hindu and The Times of India are published. It is known that 25% of the city population reads The Hindu and 20% reads The Times of India while 8% reads both the newspapers. It is also known that 30% of those who read The Hindu but not The Times of India look into advertisement and 40% of those who read The Times of India but not The Hindu look into advertisement while 50% of those who read both the newspapers look into advertisements. What is the percentage of the population who read an advertisement?
Cost price of item A is Rs. 300 less than that of item B for a shopkeeper. He marks item A and B above 80% and 40% respectively their cost prices and sold them at 20% and 40% discount respectively. If selling price of item, A is Rs. 18 more than that of item B, then what is the ratio of cost price of item A to that of item B?
Aayu, Jayu, Miyu and Keya all have different taste in literature. One reads novels, one reads poetry, one reads science fictions and one reads stories. Using following information select the type of literature enjoyed by Miyu. The novel fan has asked by Jayu to help her to collect data for Miyu. Miyu and Jayu are working on the project along with the person who enjoys science fictions. Both Keya and fan of novels are in the same class as the person who enjoys story reading. Miyu and Anu are not in the same class.
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?
The number of persons who read magazine X only is thrice the number of persons who read magazine Y. The number of persons who read magazine Y only is thrice the number of persons who read magazine X. Then, which of the following conclusions can be drawn? i. The number of persons who read both the magazines is twice the number of persons who read only magazine X. ii. The total number of persons who read either one magazine or both the magazines is twice the number of persons who read both the magazines. Select the correct answer using the code given below:
Let transaction T1 has obtained a shared mode lock S on data item Q and transaction T2 has obtained an exclusive mode lock X on data item R  Consider the following statement. I: T1 can read Q but cannot write Q. II. T2 can read R but cannot write R. Which of the above statements is / are valid?
The police arrested four criminals - P, Q, R and S. The criminals knew each other. They made the following statements: P says “Q committed the crime.” Q says “S committed the crime.” R says “I did not do it.” S says “What Q said about me is false.” Assume only one of the arrested four committed the crime and only one of the statements made above is true. Who committed the crime?