What is the difference between primary key & unique index ?
Answer Posted / palash ghosh
1)Primary key creates an implicit culstered index on a
table, unique key does not create any implicit index.
2)Columns defined as primary key does not allow null values,
where as columns defined as unique can allow null values.
3)A table can have just one primary key (can be a composite
key) where as there can be multiple unique columns (keys).
4)Primary key is a unique key with the above mentioned
features.
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How can deadlocks be resolved?
Define db2.
What is copy pending status in db2?
What is runstats and reorg in db2?
What is a cursor in programming?
Can one database have multiple instances?
How to check sequence on a table in db2?
What r the comman abends in db2, jcl and cobol???????
What does db2 mean?
What is runstats utility in db2?
What is the use of value function?
Explain about dbrm.
How do you pull up a query which was previously saved in qmf?
What is a Foreign Key?
Mention the downsides of page level lock.