If you have a unique key and there are two sessions perfoming an insert that compromises this UK, the second one will be blocked. Even if you are in read commited mode and the first transaction is not yet commited.
I think other types of constraints will do it too.
|