In a distributed system, when two databases must be updated as part of a single transaction, which transaction management technique is most appropriate?
- Isolation (I)
- Optimistic Concurrency Control (OCC)
- Pessimistic Concurrency Control (PCC)
- Two-Phase Commit (2PC)
The Two-Phase Commit (2PC) is most appropriate for managing transactions in a distributed system involving updates to multiple databases, ensuring atomicity and consistency across the distributed environment.
Loading...
Related Quiz
- _________ is a security standard that prevents the browser from interpreting user input as script.
- In a scenario where a user's session cookies are stolen via XSS, what security measures could have prevented this?
- How can you handle a situation where a database connection is lost during a transaction?
- A high-traffic website uses a cache that frequently encounters 'cache churn'. What strategy can be used to minimize this effect?
- What is the primary advantage of using a PreparedStatement in JDBC?