What is the purpose of the UNIQUE constraint in SQL?

Question Explain

This question checks knowledge of data integrity mechanisms and how to prevent duplicate entries in columns.