Transaction logs in DB2 are crucial for ________.

  • Data compression
  • Database recovery
  • Query optimization
  • Schema modification
Transaction logs in DB2 are crucial for database recovery. These logs record all changes made to the database, including inserts, updates, and deletes, in a sequential manner. In the event of a failure or a need to recover the database to a specific point in time, transaction logs play a vital role by providing a consistent record of transactions. They enable the database to be restored to a consistent state, ensuring data integrity and minimizing the risk of data loss. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *