Just try to add some more:

If you are using one central database, no risk for two concurrent transactions. Oracle has those basic stuff ( row level locking, read consistent etc...) as a commercial RDBMS, of course.
If you are implementing replication, you have your choice to have the replicated data read-only, or have the applications themselves to resolve any transaction/data conflict. It's not the database to resovle this.