Examveda

The purpose of timestamping is to avoid the use of locks.

A. True

B. False

Answer: Option B

Solution (By Examveda Team)

The statement is false. The purpose of timestamping in concurrency control is not to avoid the use of locks, but rather to provide a mechanism for ordering and scheduling concurrent transactions.

Option A: True
This option contradicts the statement provided in the question. Timestamping is not intended to replace locks; rather, it is a concurrency control mechanism used in conjunction with locks or other synchronization techniques to manage access to shared resources in a distributed database system. Timestamping assigns unique timestamps to transactions, allowing the system to determine the order in which transactions should be executed and to detect and resolve conflicts that may arise due to concurrent access to data.

Option B: False
This option correctly identifies the statement as false. While timestamping is an important aspect of concurrency control in distributed databases, its purpose is not to eliminate locks. Locks are still commonly used in conjunction with timestamping to ensure data consistency and isolation by preventing conflicting transactions from accessing or modifying the same data simultaneously.

Therefore, in response to the question, the correct option is False (Option B).

This Question Belongs to Database >> Distributed Databases

Join The Discussion

Related Questions on Distributed Databases

An autonomous homogenous environment is which of the following?

A. The same DBMS is at each node and each DBMS works independently.

B. The same DBMS is at each node and a central DBMS coordinates database access.

C. A different DBMS is at each node and each DBMS works independently.

D. A different DBMS is at each node and a central DBMS coordinates database access.