Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207492 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 / deen dayal sharma
1. PRIMARY KEY & UNIQUE KEY both uniquely identity of each
row in a table.
2. BOTH keys will not contain repeated value.
3. One table may have more than one Unique Key Constraint But
it should have only one Primary Key Constraint column.
4. BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to load data through external tables?
Explain about the analyze command in oracle?
How to return top 5 rows in oracle?
What does sharding mean?
How to unlock the sample user account in oracle?
How to do paging with oracle?
How to enter a new row into a table interactively?
Will you be able to store pictures in the database?
What is an oracle?
How to view existing locks on the database?
Explain view?
What are the execution control statements in oracle?
Where do you use decode and case statements?
Why do you create or replace procedures rather that drop and recreate.
What is set verify off in oracle?
