Difference between primary key and unique key ?
- 77 Answers
- 191038 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 / alok
There is only two Point:
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you know about normalization? Explain in detail?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
material view and view disadvantages?
What is a table in oracle?
How to use subqueries with the in operator using oracle?
What is sharded cluster?
How to invoke the data pump import utility?
What is a system tablespace?
Does facebook use oracle?
Point the difference between translate and replace?
Is oracle the best database?
Use of an integrity constraint is better to validate data. Explain
Explain how you would restore a database using RMAN to Point in Time?
What is a database table in oracle?
In which language oracle has been developed?
