Multiple choice

Which of the following contains complete record of all activities that affect the contents of a database?

  1. Transaction Log

  2. Query Language

  3. Report Writer

  4. Data Manipulation Language
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A transaction log maintains a complete chronological record of all modifications made to database contents, including inserts, updates, and deletions. This log is essential for database recovery after system failures, enabling rollback of incomplete transactions and forward recovery to restore the database to a consistent state. It also provides an audit trail for compliance and debugging.

Keep practicing — related questions