In: Accounting
A database Deadlock
a. is a lock placed on a record to prevent it from being accessed by other processes.
b. occurs when two records are accidentally assigned the same primary key
c. occurs when a unique record is accessed by several different processes simultaneously.
d. is none of the above.
The correct answer is:
d. is none of the above.
Explantion:
A database deadlock occurs when two or more transactions are waiting for each other to release locks on data, causing them to be stuck indefinitely. It's a situation where each process holds a lock on a resource that the other process needs in order to proceed, leading to a deadlock state where neither can progress.
The correct answer is: (d).