Home » MCQs » DBMS MCQs » DBMS Log-Based Recovery MCQs

All logs are created and stored in ___ storage when the deferred database method is used, and data is synced to the database when a transaction commits

8. All logs are created and stored in ___ storage when the deferred database method is used, and data is synced to the database when a transaction commits.

1. Stable
2. Unstable
3. System
4. Recovery

Answer: A) Stable

Explanation:

All logs are created and stored in stable storage when the deferred database method is used, and data is synced to the database when a transaction commits.