What is the difference between a unique index and a non-unique index?
- A non-unique index allows duplicate values in the indexed column(s)
- A non-unique index does not allow NULL values in the indexed column(s)
- A unique index allows NULL values in the indexed column(s)
- A unique index allows only unique values in the indexed column(s)
A unique index enforces uniqueness, ensuring that each indexed value is unique, while a non-unique index allows duplicate values to be stored. Understanding this difference is crucial for data integrity and query optimization.
Loading...
Related Quiz
- In what scenarios would denormalization be preferred over normalization?
- The process of converting categorical data into numerical values during data transformation is called ________.
- In the context of data modeling, what does a conceptual data model primarily focus on?
- What role does data profiling play in data modeling best practices?
- In normalization, the process of breaking down a large table into smaller tables to reduce data redundancy and improve data integrity is called ________.