COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The personal database system assumes that no two transactions will happen at the same time on one table, which is known as____
|
|
Client Server
|
|
|
Network
|
|
|
Transaction
|
|
|
Optimistic locking
|
Explanation:
Detailed explanation-1: -The term locking is used because optimistic concurrency control serves the same purpose as pessimistic locking by preventing overlapping updates. When you use optimistic locking, you do not find out that there is a conflict until just before you write the updated data.
Detailed explanation-2: -Optimistic concurrency control (OCC), also known as optimistic locking, is a concurrency control method applied to transactional systems such as relational database management systems and software transactional memory. OCC assumes that multiple transactions can frequently complete without interfering with each other.
There is 1 question to complete.