A table can have multiple UNIQUE constraints, each enforcing uniqueness on a different column or combination of columns. This is different from a PRIMARY KEY, of which a table can only have one. UNIQUE constraints are commonly used on columns like email, username, or phone number where duplicates should not occur.