Ant International interview question

How to resolve lock in sql, what method to use