In database systems, a _______ is a mechanism to control access to data items by multiple transactions.
- Buffer
- Lock
- Semaphore
- Trigger
In database systems, a lock is a mechanism used to control access to data items by multiple transactions. It helps in preventing conflicts and ensuring the consistency of the data during concurrent access. Locks can be applied at various levels, such as row-level, page-level, or table-level.
Loading...
Related Quiz
- What does AWS stand for?
- What is a primary use case for MongoDB?
- Which database indexing technique helps in optimizing query performance by storing data in a sorted order?
- Which SQL keyword is used to retrieve data from a database?
- Which metric is typically used to measure system performance in monitoring tools?