Difference between primary key and unique key ?
- 77 Answers
- 198967 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
What privilege is needed for a user to create tables in oracle?
Who developed oracle & when?
Whether any commands are used for months calculation? If so, what are they?
why dont we assign not null constraint as table level constraint.
What is set operator oracle?
Why packages are used in oracle?
Explain the blob datatype?
What is the difference between a hot backup and a cold backup in oracle?
What is catalog in Oracle?
What are the general rules on data consistency?
How to select some columns from a table in oracle?
What is recovery manager(rman) backup in Oracle?
What is the difference between formal parameters and actual parameters?
How much memory your 10g xe server is using?
What is enter substitution variable in oracle?
