The information stored in the _____ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program's abnormal termination, or a system failure such as a network discrepancy or a disk crash.
A) data dictionary
B) metadata
C) rollback manager
D) transaction log

Question

The information stored in the _____ is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program's abnormal termination, or a system failure such as a network discrepancy or a disk crash.
A) data dictionary 
B) metadata
C) rollback manager
D) transaction log

Quizplus · Accepted Answer

The transaction log is used by the DBMS to keep track of all changes made to the database during a transaction. This information is used for recovery purposes in case of a rollback, program termination, or system failure. The other options, such as the data dictionary and metadata, are used for managing and storing information about the database schema and structure. The rollback manager is a component of the DBMS that handles the process of rolling back transactions.

The Information Stored in the _____ Is Used by the DBMS