How does a relational database handle transactions and ensure data consistency?

  • Applying access control policies
  • Implementing backup strategies
  • Using transaction logs
  • Utilizing data encryption
Relational databases handle transactions by logging changes made during transactions, allowing for rollbacks in case of failure. This logging mechanism ensures data consistency by providing a point-in-time view of the database and enables recovery to a consistent state. Backup strategies, encryption, and access control are important for data protection but not directly related to transaction handling and data consistency in relational databases.
Add your answer
Loading...

Leave a comment

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