Different database types provide differing levels of guarantees about consistency and availability of data. Discuss the differences between ACID and BASE databases, as well as the claims of the CAP theorem. Also, answer the question: For databases not providing transactional guarantees, are there any techniques you can think of to provide resource locking and prevent race conditions when manipulating the data?