Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210016 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 / tom
There is two difference between them.
1. The not null constraint is by default added to primary
key, it means, primary key attribute cannot accept null
values, whereas, the attribute declared as unique can accept
null values. It is the major difference between the two.
2. Secondly, we can have only one primary key in a relation,
whereas, multiple attributes can be declared unique at the
same time.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain alias?
Can you have more than one content canvas view attached with a window ?
How to load a large xml file?
What is a partition in oracle?
How to drop an existing table in oracle?
State the difference between a primary key and foreign key?
What do you mean by a deadlock?
What is the difference between substr & instr functions?
What is data block in Oracle?
What is a view and how is it different from a table?
What is oracle datasource?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to omit columns with default values in insert statement in oracle?
What are the differences between char and varchar2 in oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
