Detailed explanation and options for the selected question.
UNIQUE ensures no two rows have the same value in a column. NOT NULL prevents NULLs, CHECK enforces conditions, and FOREIGN KEY links tables.