A database is the best solution for allowing multiple users to update records simultaneously without causing errors. Databases, especially relational databases like MySQL, PostgreSQL, and Microsoft SQL Server, are designed for concurrent access, ensuring data consistency and integrity through mechanisms like transaction management and locking.
A. Flat file does not support concurrent access efficiently, making it unsuitable for simultaneous updates.
B. Document formats like Word or PDFs are not designed for simultaneous multi-user editing.
D. Spreadsheet programs like Excel can allow multiple users to view data but are prone to errors when used for concurrent data updates.
References:
CompTIA IT Fundamentals (ITF+) Certification Guide
Official CompTIA Database Fundamentals Study Materials
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit