Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 695
|
In transaction management od database, ‘After a transaction completes successfully the changes it has made to the database persists even if there are system failures’. This property is referred to as:
|
Atomicity
|
|
|
Consistency
|
|
|
Isolation
|
|
|
Durability
|
Question 695 Explanation:
• The database should be durable enough to hold all its latest updates even if the system fails or restarts.
• If a transaction updates a chunk of data in a database and commits, then the database will hold the modified data.
• If a transaction commits but the system fails before the data could be written on to the disk, then that data will be updated once the system springs back into action.
• If a transaction updates a chunk of data in a database and commits, then the database will hold the modified data.
• If a transaction commits but the system fails before the data could be written on to the disk, then that data will be updated once the system springs back into action.
Correct Answer: D
Question 695 Explanation:
• The database should be durable enough to hold all its latest updates even if the system fails or restarts.
• If a transaction updates a chunk of data in a database and commits, then the database will hold the modified data.
• If a transaction commits but the system fails before the data could be written on to the disk, then that data will be updated once the system springs back into action.
• If a transaction updates a chunk of data in a database and commits, then the database will hold the modified data.
• If a transaction commits but the system fails before the data could be written on to the disk, then that data will be updated once the system springs back into action.