What is the purpose of a CHECK constraint?

A To prevent NULL values in a column B To verify that a foreign key exists in another table C To enforce that column values satisfy a specific condition D To ensure a column value is unique