Uttrakhand Asst. Professor Exam-54

Question

The ________ information is used to limit the amount of recovery operations to be done following a system crash resulting in the lose of volatile storage

• A.  Log
• B.  Data file
• C.  Check point
• D.  None of the above

Comments

a) log

---

It should be checkpoint

Answer 1

C) Checkpoint

"The ___________ information is used to limit the amount of recovery operations to be done following a system crash..."

If "limit" word wouldn't be there, the answer would have been option A, simply because for recovery operations, we refer to Logs following a system crash.

To optimize the recovery method we use "Checkpoints" in Logs so as to keep track of changes that have been perfectly committed to the database before the system crash thus avoiding redundant REDOs/UNDOs for already committed transactions while recovering.

Answer 2

The answer should be Checkpoint.

In Windows operating system System Restore Checkpoint is used to limit the amount of recovery operations which is being done following a system crash .

System Restore is a feature in Microsoft Windows that allows the user to revert their computer's state (including system files, installed applications, Windows Registry, and system settings) to that of a previous point in time, which can be used to recover from system malfunctions or other problems.

System restore takes the system to that point in which the restore point is created.Suppose, I created System restore point in 4-03-2018 at 2:00 am & my system crashed in 05-03-2018  at 2 pm.

Then, system restore takes the system's condition as same as 2:00 am of 04-03-2018's system condition.That means whatever data we have in 04-03-2018 system will going back to that condition and whatever work is done after 2:00 am of 04-03-2018 that will gone i.e. if any extra data is added or any new software is installed after 04-03-2018 , that 'll not recovered.