Fill in the Missing Event That Causes Deadlock in a Database.There

question 18

Multiple Choice

Fill in the missing event that causes deadlock in a database.There are two processes (P1 and P2) ,each of which needs to update two records (R1 and R2) and the following sequence leads to a deadlock:
1) P1 accesses R1 and locks it.
2) P2 accesses R2 and locks it.
3) ____
4) P2 requests R1,which is locked by P1.

• A) P2 releases R2.
• B) P1 requests R1 again.
• C) P1 requests R2,which is locked by P2.
• D) P2 releases R1.

---

Definitions:

Decision-Making Strategies

Approaches or methodologies used to select the best alternative from several options based on specific criteria or objectives.

Code of Ethics

A set of principles and guidelines designed to help professionals conduct business honestly and with integrity.

Ethical Audit

A systematic evaluation of an organization's adherence to moral principles and standards in its business operations and overall conduct.

Organizational System

The structured arrangement of roles, responsibilities, and processes within an organization, which determines how it functions and achieves its objectives.