Is reading a single record always an atomic operation? Is reading a single record always an atomic operation?

I mean, when e.g. a read (select) and write (update) query are simultaneously carried out on the same record, is it possible for the read operation to read and inconsistent record? (some field values from the old version of that record and some new values resulting from the write operation be returned)
In an ACID compliant database it is atomic