In a multi-threaded server application, what could be a potential issue if each thread opens its own database connection via a socket?

  • Reduced resource consumption as each thread manages its own connection.
  • Improved concurrency and performance due to isolated connections.
  • Increased risk of resource contention and exhaustion.
  • Guaranteed data consistency and reliability.
In a multi-threaded server application, opening a separate database connection for each thread (option c) can lead to issues like resource contention and exhaustion. This approach can consume a significant number of resources and potentially cause performance problems. The other options (a, b, and d) do not accurately describe the issues associated with this practice.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *