I’m unsure if “Synchronized” is the best way to think about this, as it leads to a bit of domain mismatch.
This discusses synchronization in a way similar to multithreading locks, which can usually be achieved by just using transactions in SQL.
Synchronization at a web app level often refers to change-merging a la EWS or git.
I don’t really see what SQL has to do with synchronization (or consistency). That is a property of the database, not the query language.