1 votes 1 votes 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 1 (B) Only 2 (C) Both 1 and 2 (D) None Databases transaction-and-concurrency + – Verma Ashish asked Aug 25, 2018 Verma Ashish 2.1k views answer comment Share Follow See all 7 Comments See all 7 7 Comments reply MiNiPanda commented Aug 25, 2018 reply Follow Share only B) is incorrect according to me.. 0 votes 0 votes Verma Ashish commented Aug 25, 2018 reply Follow Share Yeah.. You are right but checkpoints are useful in recoverability. Where i'm wrong?? 0 votes 0 votes Shaik Masthan commented Aug 25, 2018 reply Follow Share https://www.gateoverflow.in/234808/self-doubt?show=234858#c234858 check this, may it help to you 0 votes 0 votes Verma Ashish commented Aug 25, 2018 reply Follow Share The explanation given is Checkpoints are inserted to minimize the task of undo-redo in recoverability So option B is incorrect. 0 votes 0 votes MiNiPanda commented Aug 25, 2018 reply Follow Share Verma Ashish If X ensures recoverability it means that during a system crash Xwill guarantee that all the operations that have been performed till the point of crash will be maintained in the dB or maybe saved somewhere in log files so that it can be later used. Here if you relate X with checkpoint then you will see that the task of checkpoint is not so. If you know about deferred and immediate database modification we will see that there we have to undo and redo for so many times in case of system crash. This is not what we want. Checkpoints just avoid that headache for redoing and undoing to some extent if not full. 1 votes 1 votes Verma Ashish commented Aug 25, 2018 reply Follow Share Thanks. I'm not getting the correct meaning of "ensures recoverability". Now it is clear. :) 1 votes 1 votes MiNiPanda commented Aug 25, 2018 reply Follow Share It's like when you break your leg ice acts as a temporary pain "reducing" solution but only doctor + plaster can recover that crack and heal the pain :v :p If you don't apply ice(here checkpoint) then you will have to bear the pain for a longer time but it doesn't help in "curing" the damage 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes Statement A is true because strict 2 PL ensure serializibility and recoveribility . Statement B is false because checkpoints are used for minimize redo-undo operation.it is not ensure recoveribility. Mritunjay Ashish answered Sep 13, 2019 Mritunjay Ashish comment Share Follow See all 0 reply Please log in or register to add a comment.