Pessimistic Locking?

Pessimistic Locking is when you lock the record for your exclusive use until you have finished with it. It has much better integrity than optimistic locking but requires you to be careful with your application design to avoid Deadlocks.
(Read more here http://bit.ly/sql-interview)