DPL interview question

How to handle dead lock in Sql Database?