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:

Canadian Medical Association

A national, voluntary association of physicians that advocates on behalf of its members and the public for access to high-quality health care, and provides leadership and guidance to physicians.

Multinational Corporation

A large company that operates and provides goods or services in multiple countries beyond its original country of establishment, often exercising significant economic and political influence globally.

Branch Plant

A factory or office operated in a country by a foreign company, often perceived as a subordinate extension of its parent company.

Collateral Labour Markets

Secondary or peripheral segments of the labour market characterized by lower job security, lower wages, and less formal employment structures.