Difference between primary key and unique key ?
- 77 Answers
- 190510 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 oracle and what are its different editions?
How would you go about verifying the network name that the local_listener is currently using?
What is the difference between a user and a schema in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
What is a data lock in oracle?
List out the components of logical database structure of oracle database.
Can we use bind variables in oracle stored procedure?
What is the Tune Query
What is a Garbage Collection? and what is full recursive Garbage collection?
What is using clause and give example?
What happens to the indexes if a table is recovered?
How oracle handles dead locks?
How to generate query output in html format?
How to store pictures on to the database?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
