Which recovery strategy in DB2 involves restoring a database to the last consistent state before failure?

  • Rollforward Recovery
  • Flashback Recovery
  • Point-in-time Recovery
  • Crash Recovery
The correct option is Option 4: Crash Recovery. Crash recovery in DB2 involves restoring the database to the last consistent state before failure, ensuring that all transactions are either completely applied or completely undone to maintain database integrity. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *