Which type of data integrity constraint ensures that values in a column are unique within a table?
- Check constraint
- Foreign key constraint
- Primary key constraint
- Unique constraint
The unique constraint ensures that values in a column are unique within a table, thus maintaining data integrity by preventing duplicate entries.
Loading...
Related Quiz
- Scenario: During authentication testing, you notice that the application does not enforce strong password policies, allowing users to set weak passwords. How can this vulnerability impact security, and what should you recommend?
- What is the role of data profiling tools in data consistency testing?
- Scenario: In a database with employee records, you need to retrieve the names of all employees and their respective managers. The employee table has a "ManagerID" column that relates employees to their managers. Which SQL operation can you use to achieve this?
- What are the potential consequences of a successful SQL injection attack on a database?
- What is a subquery in SQL, and how is it different from a JOIN operation?