Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210092 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 / manoj routh
Both primary key and unique enforce uniqueness of the column
on which they are defined. But by default primary key
creates a clustered index on the column, where are unique
creates a nonclustered index by default. Another major
difference is that, primary key doesn't allow NULLs, but
unique key allows one NULL only.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to assign a tablespace to a users in oracle?
What is the implicit cursor in oracle?
What is blob data type in oracle?
What is a trigger and what are its types?
What is the difference between PFILE and SPFILE in Oracle?
What are internal user account in oracle?
How to empty your oracle recycle bin?
How to convert times to characters in oracle?
How to create a table interactively?
How does Oracle guarantee data integrity of data changes?
What to do if dba lost the system password?
What is a nvl function?
How to connect to a local oracle 10g xe server?
What is difference between cartesian join and cross join?
Can select statements be used on views in oracle?
