Question

Which constraint ensures that a column cannot store NULL values and also guarantees that all values in the column are unique?

Q: Answer-Which constraint ensures that a column cannot store NULL values and also guarantees that all values...

SQL Constraints NOT NULL Column cannot be NULL. Does NOT enforce uniqueness. UNIQUE All values must be distinct. But allows one NULL in most DBMS. CHECK Value must satisfy a given condition e.g., age 0. DEFAULT Assigns a default value if no value provided. PRIMARY KEY NOT NULL and UNIQUE combined. - Cannot be NULL - Must be unique across all rows - Only one primary key per table can be composite