My understanding is that unlike CHAEK and FOREIGN KEY constraints, we
cannot have UNIQUE ones NOT ENFORCED, and the reason is very simple:
UNIQUE constraints are implemented as UNIQUE indexes. One cannot turn
off uniquenedss of an index easily

Am I correct?