Computer Science Engineering (CSE) Exam > Computer Science Engineering (CSE) Questions > Consider the following partial Schedule S inv...
Start Learning for Free
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).
Q. Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?
- a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicity
- b)Schedule S is non-recoverable and cannot ensure transaction atomicity
- c)Only T2 must be aborted and then re-started to ensure transaction atomicity
- d)Schedule S is recoverable and can ensure atomicity and nothing else needs to be done
Correct answer is option 'B'. Can you explain this answer?
| FREE This question is part of | Download PDF Attempt this Test |
Verified Answer
Consider the following partial Schedule S involving two transactions T...
if transaction fails, atomicity requires effect of transaction to be undone. Durability states that once transaction commits, its change cannot be undone (without running another, compensating, transaction). Recoverable schedule: A schedules exactly where, for every set of transaction Ti and Tj. If Tj reads a data items previously written by Ti, then the commit operation of Ti precedes the commit operation of Tj. Aborting involves undoing the operations and redoing them since by the time stamp it is aborted.
Option (A): T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicity. It is incorrect because it says abort transaction T2 and then redo all the operations. But there is no gaurantee that it will succeed this time as again T1 may be fail.
Option(B): Schedule S is non-recoverable and cannot ensure transaction atomicity. Correct, it is by definition an irrecoverable schedule so now even if we start to undo the actions one by one(after t1 fails) in order to ensure transaction atomicity. Still we cannot undo a commited transaction. hence this schedule is irrecoverable by definition and also not atomic since it leaves the database in an inconsistent state. Simply dirty read so nonrecoverable.
Option (C): Only T2 must be aborted and then re-started to ensure transaction atomicity. It is incorrect because it says abort only transaction T2 and then redo all the T2 operations. But this is dirty read problem as it is reading the data item A which is written by T1 and T1 is not committed. Again it will be the dirty read problem. So incorrect.
Option (D): Schedule S is recoverable and can ensure transaction atomicity and nothing else needs to be done. Incorrect, it is clearly saying that schedule s is recoverable but it is irrecoverable because T2 read the data item A which is written by T1 and T1 failed and rollback, at the rollback T1 start undo all operations and modified the value of A with previous value but T2 is already committed so T2 can't change the read value of A which was earlier taken from T1.
Option (A): T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicity. It is incorrect because it says abort transaction T2 and then redo all the operations. But there is no gaurantee that it will succeed this time as again T1 may be fail.
Option(B): Schedule S is non-recoverable and cannot ensure transaction atomicity. Correct, it is by definition an irrecoverable schedule so now even if we start to undo the actions one by one(after t1 fails) in order to ensure transaction atomicity. Still we cannot undo a commited transaction. hence this schedule is irrecoverable by definition and also not atomic since it leaves the database in an inconsistent state. Simply dirty read so nonrecoverable.
Option (C): Only T2 must be aborted and then re-started to ensure transaction atomicity. It is incorrect because it says abort only transaction T2 and then redo all the T2 operations. But this is dirty read problem as it is reading the data item A which is written by T1 and T1 is not committed. Again it will be the dirty read problem. So incorrect.
Option (D): Schedule S is recoverable and can ensure transaction atomicity and nothing else needs to be done. Incorrect, it is clearly saying that schedule s is recoverable but it is irrecoverable because T2 read the data item A which is written by T1 and T1 failed and rollback, at the rollback T1 start undo all operations and modified the value of A with previous value but T2 is already committed so T2 can't change the read value of A which was earlier taken from T1.
|
Explore Courses for Computer Science Engineering (CSE) exam
|
|
Similar Computer Science Engineering (CSE) Doubts
Top Courses for Computer Science Engineering (CSE)View all
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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer?
Question Description
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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about 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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for 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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer?.
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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about 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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for 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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer?.
Solutions for 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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE).
Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of 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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of
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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer?, a detailed solution for 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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer? has been provided alongside types of 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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer? theory, EduRev gives you an
ample number of questions to practice 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).Q.Suppose that the transaction T1 fails immediately after time instance 9. Which one of the following statements is correct?a)T2 must be aborted and then both T1 and T2 must be re-started to ensure transaction atomicityb)Schedule S is non-recoverable and cannot ensure transaction atomicityc)Only T2 must be aborted and then re-started to ensure transaction atomicityd)Schedule S is recoverable and can ensure atomicity and nothing else needs to be doneCorrect answer is option 'B'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
|
|
Explore Courses for Computer Science Engineering (CSE) exam
|
|
Suggested Free Tests
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
|
© EduRev
|
Education Revolution
|
Follow Us
|
Signup to see your scores
go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup