Podcast
Play an AI-generated podcast conversation about this lesson
Questions and Answers
Why is the log periodically backed up to archival storage?
Why is the log periodically backed up to archival storage?
- To control access to the database
- To optimize search operations on the database
- To store additional copies of data items
- To guard against disk or catastrophic failures (correct)
What is the primary purpose of the log in a database system?
What is the primary purpose of the log in a database system?
- To store data items in the database
- To keep track of all transaction operations (correct)
- To control access to the database
- To act as a primary storage for database values
What type of failures does the log remain unaffected by?
What type of failures does the log remain unaffected by?
- Disk or catastrophic failures (correct)
- Software failures only
- Network failures only
- Hardware failures only
