18 Questions
Match the following database recovery mechanisms with their descriptions:
Checkpoint facility = periodically suspends all processing and synchronizes its files and journals to establish a recovery point. Journalizing facilities = provide back-up copies of portions of or the entire database. Backup facilities = maintain an audit trail of transactions and database changes. Recovery manager = manages the recovery process by rerunning the transactions that were incomplete at the time of failure.
Match the following database recovery techniques with their purposes:
Restore/Rerun technique = used to restore the database to a consistent state after a failure. Disk Mirroring = used to maintain multiple copies of the database for high availability. Cold backup = only a selected portion of the database is shut down from use. Hot backup = full backup of the entire database, taken while the database is still in use.
Match the following database recovery mechanisms with their descriptions:
Checkpoint facility = used to establish a recovery point by suspending all processing and synchronizing files and journals. Journalizing facilities = used to maintain an audit trail of transactions and database changes. Backup facilities = used to provide back-up copies of portions of or the entire database. Recovery manager = used to manage the recovery process by re-applying the transactions.
Match the following database recovery concepts with their descriptions:
Transaction Integrity = ensures that database transactions are executed reliably and securely. Recovery Point = a consistent state of the database, used as a reference for recovery. Recovery Manager = manages the recovery process by re-applying the transactions. Audit Trail = a record of all transactions and database changes, used for recovery.
Match the following database recovery techniques with their advantages:
Disk Mirroring = provides high availability and instant failover in case of a failure. Restore/Rerun technique = minimizes downtime by quickly restoring the database to a consistent state. Cold backup = ensures data integrity by creating a full backup of the database. Checkpoint facility = reduces the time required for recovery by establishing a recovery point.
Match the following database recovery mechanisms with their purposes:
Journalizing facilities = used to maintain an audit trail of transactions and database changes for recovery. Backup facilities = used to provide back-up copies of portions of or the entire database for recovery. Recovery manager = used to manage the recovery process by re-applying the transactions. Checkpoint facility = used to establish a recovery point by suspending all processing and synchronizing files and journals.
Match the recovery technique with the corresponding type of database failure:
Rollback = Incorrect Data Switch to duplicate database = System Failure
Match the method of recovery with the corresponding scenario:
Restart from the most recent checkpoint = Incorrect Data Switch to duplicate database = Database Destruction Develop a detailed, written disaster recovery plan = Disaster Recovery
Match the challenge with the appropriate recovery technique:
Input of invalid data = Rollback Disk failure = Switch to duplicate database Natural or manmade disaster = Develop a detailed, written disaster recovery plan Human intervention to correct errors = Incorrect Data
Match the recovery method with the type of database failure it addresses:
Switch to duplicate database = Database Destruction Rollback = Incorrect Data
Match the recovery technique with the corresponding scenario:
Forward Recovery/Rollforward = Maintaining Transaction Integrity Re-starting from the most recent checkpoint = Checkpoint facility Disk Mirroring = Disk failure Restore/Rerun technique = Aborted Transactions
Match the database failure type with the appropriate recovery manager solution:
Aborted Transactions = Rollback Incorrect Data = Compensating transactions introduced through human intervention System Failure = Switch to duplicate database Database Destruction = Switch to duplicate database
Match the following database recovery techniques with their descriptions:
Recovery Manager = Allows the DBMS to restore the database to a correct condition and restart processing transactions when a failure occurs Disk Mirroring = A technique that involves reprocessing the day’s transactions against the backup copy of the database Restore/Rerun = Keeping at least two copies of the database and updated simultaneously Checkpoint Facility = Not mentioned in the passage
Match the following ACID properties with their descriptions:
Atomic = Changes to the database are not revealed to users until the transaction is committed Consistent = The transaction cannot be subdivided, and hence, it must be processed in its entirely or not at all Isolated = Any database constraints that must be true before the transaction must also be true after the transaction Durable = Changes are permanent
Match the following database recovery techniques with their descriptions:
Disk Mirroring = Keeping at least two copies of the database and updated simultaneously Recovery Manager = Used to reverse the changes made by transactions that have aborted, or terminated abnormally Restore/Rerun = A technique that involves reprocessing the day’s transactions against the backup copy of the database Checkpoint Facility = Not mentioned in the passage
Match the following database recovery techniques with their descriptions:
Backward Recovery / Rollback = Used to reverse the changes made by transactions that have aborted, or terminated abnormally Recovery Manager = Allows the DBMS to restore the database to a correct condition and restart processing transactions when a failure occurs Restore/Rerun = Keeping at least two copies of the database and updated simultaneously Checkpoint Facility = Not mentioned in the passage
Match the following database recovery techniques with their descriptions:
Recovery Manager = A technique that involves reprocessing the day’s transactions against the backup copy of the database Restore/Rerun = Allows the DBMS to restore the database to a correct condition and restart processing transactions when a failure occurs Disk Mirroring = Keeping at least two copies of the database and updated simultaneously Checkpoint Facility = Not mentioned in the passage
Match the following database recovery techniques with their descriptions:
Checkpoint Facility = Not mentioned in the passage Recovery Manager = Allows the DBMS to restore the database to a correct condition and restart processing transactions when a failure occurs Restore/Rerun = A technique that involves reprocessing the day’s transactions against the backup copy of the database Backward Recovery / Rollback = Used to reverse the changes made by transactions that have aborted, or terminated abnormally
Test your knowledge on forward recovery and rollforward techniques in database management. Learn about how after-images are used to quickly move the database forward after a failure, and the different types of database failures like aborted transactions and incorrect data.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free