What does the CAP theorem state? Explain with a practical example why it is impossible to simultaneously ensure absolute consistency (Consistency) and availability (Availability) in a distributed system under network partition (Partition Tolerance).