The SQL ____________ statement is used to validate the uniqueness of values in a column.
- CHECK
- CONSTRAINT
- PRIMARY KEY
- UNIQUE
The SQL UNIQUE constraint ensures that all values in a column are unique, meaning no two rows in the table have the same value in that column. It's used to enforce data integrity and maintain uniqueness.
Loading...
Related Quiz
- In the context of CI/CD (Continuous Integration/Continuous Delivery), when should database tests be executed?
- Which type of access control model is commonly used in government and military systems, where access is based on a need-to-know basis?
- In a SQL query with multiple JOINs, what is the significance of the join order?
- During database table testing, you find that certain columns lack appropriate indexing, resulting in slow query performance. How would you optimize the database tables to improve query performance?
- What is the main reason for conducting database testing?