Great News!
Many students who study using our platform have reported that a large number of the practice questions here are very similar to those that appear in real exams. View Courses
Many students who study using our platform have reported that a large number of the practice questions here are very similar to those that appear in real exams. View Courses
What is the primary purpose of a transaction log in a database management system?
The Correct Answer is: A. To keep a record of all changes made to the data
A transaction log in a database management system records every change made to the data, including insertions, updates, and deletions. This log is crucial for ensuring data integrity and supporting recovery processes. If a system failure occurs, the transaction log allows the database to roll back incomplete transactions or redo committed transactions to maintain a consistent state.
Why the other options are incorrect:
B. To store user credentials for database access
User credentials are managed separately, typically in system tables or authentication services, not in the transaction log.
C. To improve the performance of queries
Transaction logs are not designed to enhance query performance; indexing and query optimization techniques serve that purpose.
D. To store a backup of the database
Backups are separate copies of the database taken for recovery purposes; transaction logs help in recovery but are not backups themselves.
Discover a range of courses designed to provide you with the knowledge and skills needed to excel in your chosen field.
You don’t need one month to study and pass your test.
With Prepsaret, it takes you a few days to grasp all the concepts needed to pass your exams