Multiple choice

Which of the following recovery techniques that recovers from non-catastropic transaction failure, is the one that do not physically update the database on disk, until a transaction reaches its commit point?

  1. System log

  2. Deferred update

  3. Immediate update

  4. Rollback

  5. Savpoint
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This is a recovery technique that recovers from non-catastropic transaction failure is the one that do not physically update the database on disk, until a transaction reaches its commit point.

Keep practicing — related questions