Register

Ace Booklet

629 views
2 votes
2 votes

The schedule S:

T1: Read(X); 

T2: Write(X);

T2: Write(Y);

T3: Write(Y);

T1: Write(Y);

T1: commit; 

T2: commit;

T3: commit;

is Recoverable or non-recoverable?

User Avatar

1 Answer

Best answer
4 votes
4 votes
yes, it is recoverable as there is no dirty read
• selected by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
Ajit J asked Nov 28, 2018
696 views
SQL (ACE Booklet)
Consider the following subquery on the relation R(A,B,C,D) SELECT […..] FROM R GROUP BY A,B Assuming A,B,C,D take integer values, which of the following can appear in the position marked as […..] MIN(C+D) A,B C,D 2 only 1 and 2 only 1,2,3 none
Consider the following subquery on the relation R(A,B,C,D)SELECT […..] FROM R GROUP BY A,BAssuming A,B,C,D take integer values, which of the following can appear in the...
User Avatar
0 votes
0 votes
0 answers
2
joshi_nitish asked Jun 20, 2017
638 views
ace practice booklet
User Avatar
0 votes
0 votes
1 answer
3
vishwa ratna asked Nov 12, 2016
459 views
Ace Booklet Question
I feel that answer is none of the above , because in question it is given AB is key , so any partial dependency will not be accepted , so none will be in 2NF. what you say , anyways the answer in booklet is D
I feel that answer is none of the above , because in question it is given AB is key , so any partial dependency will not be accepted , so none will be in 2NF.what you say...
User Avatar
0 votes
0 votes
2 answers
4
Shivam_j asked Oct 16, 2022
749 views
Ace Gate practice booklet Volume 1
Class B network on the internet has a subnet mask of 255.255.119.0 what is maximum possible hosts per subnet. Assuming Classfull Addressing Scheme
Class B network on the internet has a subnet mask of 255.255.119.0 what is maximum possible hosts per subnet. Assuming Classfull Addressing Scheme
User Avatar
Link Copied!