Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210015 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 is java oracle used for?
How to use fetch statement in a loop?
Explain how are indexes update?
How to convert characters to numbers in oracle?
What are the general rules on data consistency?
How to update values on multiple rows in oracle?
What are the ways tablespaces can be managed and how do they differ?
How to connect to the server with user account: sys?
What privilege is needed for a user to create tables in oracle?
How to install oracle database 10g xe?
How to resolve name conflicts between variables and columns?
What privilege is needed for a user to delete rows from tables in another schema?
How to convert csv to table in oracle?
How to run create database statement again?
How to return top 5 rows in oracle?
