Difference between primary key and unique key ?
- 77 Answers
- 197773 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / prashant t.
First difference is that primary key doesn't accept null
values whereas unique accepts one or multiple.
second difference is that Clustered index is created on
Primary key constraint and non clustered unique indexes is
created on Unique key constraint.
| Is This Answer Correct ? | 320 Yes | 94 No |
Post New Answer View All Answers
Are truncate and delete commands same? If so why?
How to use existing values in update statements using oracle?
How to call a sub procedure?
What are named parameters?
what happened to the global index when I truncate the data in one of the partition?
how to clone 9i Database on to 10g Database.
Can we commit inside a function in oracle?
How to test null values?
Difference between hot backup vs. Cold backup?
What are the restrictions in a oracle read only transaction?
What are oracle functions?
What is bind variable in oracle 11g?
How to calculate date and time differences in oracle?
How can you merge two tables in oracle?
Explain database link?
