So long as the database allows concurrency, then anomalies are possible. So you could do have two transactions that are going on at once and their operations may be in some way interleaved. And so the database may choose to provide isolation levels to you. There's nothing specific to relational or non-relational data to the SQL language or any other query language.