Register

GATE CSE 2003 | Question: 29, ISRO2009-73

14,893 views
51 votes
51 votes

Which of the following scenarios may lead to an irrecoverable error in a database system?

  1. A transaction writes a data item after it is read by an uncommitted transaction
  2. A transaction reads a data item after it is read by an uncommitted transaction
  3. A transaction reads a data item after it is written by a committed transaction
  4. A transaction reads a data item after it is written by an uncommitted transaction
User Avatar

5 Answers

1 votes
1 votes

A transaction is reading a data item after it is written by an uncommitted transaction, the schedule will be irrecoverable.

This is irrecoverable Schedule because T2 reads a updated value before the commit operation of T1.

User Avatar
Page:
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

25 votes
25 votes
3 answers
6
Kathleen asked Sep 16, 2014
23,552 views
GATE CSE 2003 | Question: 19, ISRO2009-24
Suppose the numbers $7, 5, 1, 8, 3, 6, 0, 9, 4, 2$ ... $9 \ 8 \ 6 \ 4 \ 2 \ 3 \ 0 \ 1 \ 5 \ 7$
Suppose the numbers $7, 5, 1, 8, 3, 6, 0, 9, 4, 2$ are inserted in that order into an initially empty binary search tree. The binary search tree uses the usual ordering o...
User Avatar
56 votes
56 votes
6 answers
7
Kathleen asked Sep 17, 2014
29,519 views
GATE CSE 2003 | Question: 82, ISRO2009-1
The subnet mask for a particular network is $255.255.31.0.$ Which of the following pairs of $\text{IP}$ addresses could belong to this network? $172.57.88.62$ and $172.56.87.23$ $10.35.28.2$ and $10.35.29.4$ $191.203.31.87$ and $191.234.31.88$ $128.8.129.43$ and $128.8.161.55$
The subnet mask for a particular network is $255.255.31.0.$ Which of the following pairs of $\text{IP}$ addresses could belong to this network?$172.57.88.62$ and $172.56....
User Avatar
44 votes
44 votes
5 answers
8
Kathleen asked Sep 16, 2014
15,144 views
GATE CSE 2003 | Question: 25, ISRO2009-12
Using a larger block size in a fixed block size file system leads to better disk throughput but poorer disk space utilization better disk throughput and better disk space utilization poorer disk throughput but better disk space utilization poorer disk throughput and poorer disk space utilization
Using a larger block size in a fixed block size file system leads tobetter disk throughput but poorer disk space utilizationbetter disk throughput and better disk space u...
User Avatar
Link Copied!