explanation of the different types of locking mechanisms used in Database Management Systems (DBMS) and how they help in maintaining data consistency and preventing data anomalies

explanation of the different types of locking mechanisms used in Database Management Systems (DBMS) and how they help in maintaining data consistency and preventing data anomalies. Additionally, I would like an analysis of how deadlocks occur in DBMS and the various strategies that can be implemented for deadlock detection and resolution. The response should cover: 1. A comprehensive overview of locking mechanisms such as shared locks, exclusive locks, and others, including their advantages and disadvantages. 2. Explanation of two-phase locking protocol and its role in ensuring serializability. 3. Examples of how locks are utilized in real-world database systems to manage concurrent transactions. 4. Detailed analysis of what causes deadlocks in a DBMS environment and examples to illustrate these scenarios. 5. Strategies for deadlock detection, such as wait-for graphs, and approaches for deadlock resolution like timeout and preemption. The answer should be well-articulated and concise, around 700-800 words, and should include diagrams or charts where applicable to enhance understanding.