One is the READ_COMMITTED isolation level. This is the only level that supports both a pessimistic (locking-based) and an optimistic (version-based) concurrency control model.
The other is the SNAPSHOT isolation level that supports only an optimistic concurrency control model.