Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210239 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
What happens in oracle commit?
How to create a table interactively?
List out the types of joins.
How to see the table columns used in an index?
What are the advantages of oracle 12c?
What is snapshot is too old? Give and example for better understand.
Which is better Oracle or MS SQL? Why?
What are advantages of dateset in datastage?
What are the uses of synonyms?
What is an oracle transaction?
What is the sid in oracle?
How to connect asp pages to oracle servers?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to define an anonymous procedure without variables?
Please explain oracle left join with an example?
