Difference between primary key and unique key ?
- 77 Answers
- 199710 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 / sunil upadhyay
the basic difference is that primary key can not have null
value whereas Unique key can have null values.two null
value are not same.One table may have more than one Unique
Key Constraint
columns, but should have only one Primary Key Constraint
column.
| Is This Answer Correct ? | 88 Yes | 51 No |
Post New Answer View All Answers
Explain self joins in oracle?
Can we commit inside a function in oracle?
what are actual and formal parameters?
Explain the use of indexes option in imp command.
Why should I use oracle database?
What is program global area (pga) in oracle?
How remove data files before opening a database?
What are the uses of linked server and explain it in detail?
What are the tools for Oracle ?
What is a static data dictionary in oracle?
How to put more than 1000 values into an oracle in clause?
What is logical backup in oracle?
Explain the truncate in oracle?
What is Segment Advisor in Oracle?
How to set up autotrace for a user account?
