Which keyword must you add to your index definition in the CREATE INDEX statement to ensure that no duplicate values of the key column can exist?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- What is true about UNIQUE KEY? Choose all that apply
- For which constraints are indexes created when the constraint is added?
- Which keyword is used in the select query to remove duplicates?
- When creating an index using the CREATE INDEX statement,the UNIQUE and BITMAP keywords may be used together.
- Which of following will require index.
- For which constraints are indexes created when the constraint is added?
- While creating a table Primary key is defined but not Primary Index, then this will be considered as Primar...
- While creating a table Primary key is defined but not Primary Index, then this will be considered as Primar...