Difference between primary key and unique key ?
- 77 Answers
- 198091 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 / priyranjan das
The basic differences between Primary Key and Unique key are as follows.
1) By default Primary Key will generate Clustured Index
whereas Unique Key will Generate Non-Clustured Index.
2) Primary Key is a combination of Unique and NOT NULL Constraints so it can’t
have duplicate values or any NUll
Whereas for Oracle UNIQUE Key can have any number of NULL whereas for SQL
Server It can have only one NULL
3) A table can have only one PK but It can have any number of UNIQUE Key.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is oracle rowcount?
How to rollback the current transaction in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Explain integrity constraints?
What is oracle thin client?
What are the restrictions in a oracle read only transaction?
Why use resource manager in Oracle?
What are the system predefined user roles?
What are the logical operations?
What is columnar storage what is the advantage?
What is oracle server autotrace in oracle?
What are the oracle built-in data types?
Explain parameter file in oracle.
What is oracle datasource?
How index is implemented in oracle database?
