The greatest risk if two users have concurrent access to the same database record is Data Integrity. This is because concurrent access to the same record can lead to conflicts and inconsistencies in the data, resulting in data being lost or corrupted. Data integrity is the assurance that the data stored in the database is accurate, consistent, and reliable.
ref: https://docs.google.com/document/d/15AgfSOKqg-51pM8O9zp08DHXIrLlXw6Ir4ae_m0WkTY
The greatest risk if two users have concurrent access to the same database record is Data Integrity. This is because concurrent access to the same record can lead to conflicts and inconsistencies in the data, resulting in data being lost or corrupted. Data integrity is the assurance that the data stored in the database is accurate, consistent, and reliable.
Although referential integrity is primarily concerned with relationships between different tables, it poses a direct risk to data integrity, since concurrent accesses updating the same records can compromise data integrity.
It is critical that database integrity and availability are maintained. This is ensured through the following controls:
• Establish controls to handle concurrent access problems, such as multiple users desiring to updatethe same data elements at the same time
The greatest risk if two users have concurrent access to the same database record is Data Integrity. This is because concurrent access to the same record can lead to conflicts and inconsistencies in the data, resulting in data being lost or corrupted. Data integrity is the assurance that the data stored in the database is accurate, consistent, and reliable.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
7k1xt
3 days, 10 hours agozvykcn
1 month, 3 weeks agotundekakaaki
3 months, 1 week agoscriptkiddie
5 months agoSwallows
5 months, 1 week ago5b56aae
8 months, 1 week agoOlatoyimika
8 months, 2 weeks agofori12
9 months, 1 week agoBodooh
1 year, 1 month agoPC2323
1 year, 3 months agokertyce
1 year, 10 months agotapsshore
1 year, 11 months agoAWS56
2 years, 3 months agoVictor83516
2 years, 3 months ago