BNP Paribas Interview Question

handling deadlocks in SQL server