Year 11 DP CAT 2 CBT Third Term

___ is the process of moving back the database to a consistent state after a crash?

• Crash Recovery

• Crash Transfer

• Crash Survival

• Database Security

is a history of actions executed by a database management system

• Check pointing

• Log

• Encryption

• DBMS

___ involves taking periodic record of the database state

• Media recovery

• Logging

• Check pointing

• Fragmentation

the process of retracing the actions of a database before the crash and bringing the system back to the exact state that it was in before the crash is called ____

• Logging history during redo

• Repeating history during undo

• Logging changes during undo

• Repeating history during redo

Any change to an object is first recorded in the log.

What principle of ARIES is this?

• Analysis principle

• Logging changes during undo

• Write ahead Logging

• Execution principle

What is crash recovery in the context of computer systems?

• Restoring a crashed system to its previous state

• Recovering data from a crashed hard drive

• Restarting the computer after a crash

• Repairing damaged system files

1. What is a transaction in the context of crash recovery?

• 1. a) A system backup process

• 1. b) A failed computer component

• 1. c) An atomic unit of work that must be completed as a whole

• 1. d) A type of software update

1. What is a write-ahead log (WAL) in crash recovery?

• 1. a) A log file that records changes before they are applied to the database

• 1. b) A backup file created after a crash

• 1. c) A tool to analyze crash reports

• 1. d) A software feature to prevent crashes from happening

Which of the following is a recovery procedure used in the ARIES algorithm to achieve crash recovery?

• A) Media recovery

• B) Checkpoint

• C) Undo

• D) All of the above

What does ARIES stand for?

• Algorithm for Restoring Integrity and Ensuring Security

• Advanced Recovery and Isolation for Efficient Systems

• Automated Recovery and Isolation for Enhanced Security

• Algorithm for Recovery and Isolation Exploiting Semantics