An optimistic approach to concurrency control is called:
A) versioning.
B) denormalization.
C) deadlock resolution.
D) none of the above.

Question

Quizplus · Accepted Answer

Versioning is an optimistic approach to concurrency control where each transaction works on a separate version of data rather than locking the data. This allows multiple transactions to access the same data simultaneously without blocking or waiting for each other, thus improving overall system performance. Therefore, option A is the correct answer. Denormalization is not related to concurrency control, and deadlock resolution is a technique used in pessimistic concurrency control.

An Optimistic Approach to Concurrency Control Is Called