Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207599 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
How to resolve the ORA-39133 error in Oracle?
How do we represent comments in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to compare dates in oracle sql?
how can we store any pdf file in oracle
How to view existing locks on the database?
What are the different windows events activated at runtime ?
How to use null as conditions in oracle?
How can we view last record added to a table?
How to create tables for odbc connection testing?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is a subquery?
What is the difference between PFILE and SPFILE in Oracle?
What is user managed backup in Oracle?
Explain implicit cursor.
