If you have active-active or with replicas then it will not be considered conventional RDBMS.

There is no one way to setup such a system or write to it. For instance, you can choose to write both or write in one and log replication to another.

The consistency/availability will depend on how you set up and write to these nodes.

Bottom line, once you have more than one node, the system can never be CA.