Transactional Operation Behavior
Read
Transactional reads are non-blocking and are executed at read committed isolation level. A read operation will return the latest committed image of the record and will not be blocked by any active transaction.
Add, Delete and Update
Write operations on a record written by another active transaction will wait for that transaction to finish. This means that a record dirtied by a transaction cannot be updated by another transaction until the first transaction is committed, rolled-back or times out.