Which option best describes the use of CAP theorem in a database system?

Correct Answer: A

a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition

CAP theorem is used in Advanced DBMS because a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition.