In DB2, what is the significance of primary keys in tables?
- They allow NULL values in the column
- They automatically create indexes
- They define the order of the rows
- They ensure uniqueness of each row
Primary keys in DB2 tables play a crucial role in ensuring the uniqueness of each row. They enforce entity integrity by ensuring that no two rows have the same values in the specified column or combination of columns. This uniqueness constraint helps maintain data accuracy and consistency.
Loading...
Related Quiz
- Scenario: A security audit reveals unauthorized access attempts in a DB2 database. What steps should the DBA take to investigate and mitigate potential security risks?
- How does DB2 handle invalid XML characters within tags?
- DB2 Visual Explain aids in optimizing query performance by identifying potential ________.
- Database Services in DB2's architecture are responsible for ________.
- Visual Explain assists in identifying areas for query ________.