Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207518 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 an oracle wallet?
Explain the use of grant option in imp command.
What is the difference between translate and replace in oracle?
How to use existing values in update statements using oracle?
How to rebuild an index in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to use subqueries with the in operator using oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Query to retrieve record for a many to many relationship ?
Explain do view contain data?
What is save point in oracle database?
What is an oracle database?
Difference between the “verify” and “feedback” command?
What is an oracle?
What is integrity and what is constraint??Explain with example
