The important thing is to understand your database's concurrency model. They don't all work the same way. This causes problems e.g. for SQL Server developers who are new to Oracle, or vice versa, and naively assume that everything is the same.