Computer Science Engineering (CSE) Exam > Computer Science Engineering (CSE) Questions > Which of the following statement is/are incor...
Start Learning for Free
Which of the following statement is/are incorrect?
A: A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.
B: Checkpoint in schedules are inserted to ensure recoverability.
A: A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.
B: Checkpoint in schedules are inserted to ensure recoverability.
- a)Only 1
- b)Only 2
- c)Both 1 and 2
- d)None
Correct answer is option 'B'. Can you explain this answer?
Verified Answer
Which of the following statement is/are incorrect?A:A schedule followi...
Basic two phase locking protocol ensures only conflict serializability and strict two phase locking protocol ensures recoverability as well. So statement A is correct. Checkpoints are inserted to minimize the task of undo-redo in recoverability. So, statement B is not correct. Hence correct option B is correct choice.
Most Upvoted Answer
Which of the following statement is/are incorrect?A:A schedule followi...
< b="" />Incorrect Statement:< />
The incorrect statement is:
B: Checkpoint in schedules are inserted to ensure recoverability.
< b="" />Explanation:< />
1. A schedule following strict two-phase locking protocol is conflict serializable as well as recoverable:
- This statement is correct. The strict two-phase locking (2PL) protocol ensures conflict serializability by requiring that a transaction acquire and hold all its exclusive locks until it is ready to release them, and by forcing a transaction to release all its locks before acquiring any new locks. The 2PL protocol also ensures recoverability by ensuring that a transaction's updates are not visible to other transactions until it commits, and by allowing for the undoing of a transaction's updates if it aborts.
2. Checkpoints in schedules are inserted to ensure recoverability:
- This statement is incorrect. Checkpoints in schedules are not inserted to ensure recoverability. Rather, checkpoints are used to improve the efficiency of recovery processes. A checkpoint is a point in a schedule where the system records the state of the database and the progress of transactions. When a failure occurs, the system can use the information recorded at the last checkpoint to reduce the amount of work required for recovery. By starting the recovery process from the last checkpoint, the system can avoid processing transactions that were already committed or aborted before the failure.
< b="" />Conclusion:< />
Based on the above explanation, the incorrect statement is B: Checkpoint in schedules are inserted to ensure recoverability.
The incorrect statement is:
B: Checkpoint in schedules are inserted to ensure recoverability.
< b="" />Explanation:< />
1. A schedule following strict two-phase locking protocol is conflict serializable as well as recoverable:
- This statement is correct. The strict two-phase locking (2PL) protocol ensures conflict serializability by requiring that a transaction acquire and hold all its exclusive locks until it is ready to release them, and by forcing a transaction to release all its locks before acquiring any new locks. The 2PL protocol also ensures recoverability by ensuring that a transaction's updates are not visible to other transactions until it commits, and by allowing for the undoing of a transaction's updates if it aborts.
2. Checkpoints in schedules are inserted to ensure recoverability:
- This statement is incorrect. Checkpoints in schedules are not inserted to ensure recoverability. Rather, checkpoints are used to improve the efficiency of recovery processes. A checkpoint is a point in a schedule where the system records the state of the database and the progress of transactions. When a failure occurs, the system can use the information recorded at the last checkpoint to reduce the amount of work required for recovery. By starting the recovery process from the last checkpoint, the system can avoid processing transactions that were already committed or aborted before the failure.
< b="" />Conclusion:< />
Based on the above explanation, the incorrect statement is B: Checkpoint in schedules are inserted to ensure recoverability.
|
Explore Courses for Computer Science Engineering (CSE) exam
|
|
Similar Computer Science Engineering (CSE) Doubts
Top Courses for Computer Science Engineering (CSE)View all
Top Courses for Computer Science Engineering (CSE)
Question Description
Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer? for Computer Science Engineering (CSE) 2025 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 Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2025 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer?.
Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer? for Computer Science Engineering (CSE) 2025 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 Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2025 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer?.
Solutions for Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect 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 Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of
Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer?, a detailed solution for Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer? has been provided alongside types of Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect answer is option 'B'. Can you explain this answer? theory, EduRev gives you an
ample number of questions to practice Which of the following statement is/are incorrect?A:A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B:Checkpoint in schedules are inserted to ensure recoverability.a)Only 1b)Only 2c)Both 1 and 2d)NoneCorrect 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
|
|
Signup to solve all Doubts
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
|
© EduRev
|
Education Revolution
|
|
Signup to see your scores
go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup