When using an optimistic approach,a transaction reads the database,executes the needed computations,and makes the updates to a private copy of the database values.

Question

Quizplus · Accepted Answer

In an optimistic approach, a transaction first reads the database, then computes and makes updates to a private copy of database values. It assumes that no other transaction will concurrently modify the same data, and only commits the changes after ensuring that there were no conflicting updates from other transactions.

When Using an Optimistic Approach,a Transaction Reads the Database,executes the Needed