What is a database deadlock, and how do you prevent and handle it?

Write or say your answer first, then compare it with the model answer.