Multiple choice general knowledge

The following types of check-points can be possibly implemented:

  1. Only Time based check-point frequency

  2. Only LUW (Logical Unit of Work) based frequency

  3. Both Time and LUW based frequency

  4. It is automatically decided by the application

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Checkpoint mechanisms can implement both Time-based frequency (periodic checkpoints) and LUW-based (Logical Unit of Work) frequency where checkpoints occur after certain transaction completions. Using both provides better recovery granularity. Option D is incorrect - applications must explicitly configure checkpoint strategy.