Difference between primary key and unique key ?
- 77 Answers
- 191045 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 add another datafile to a tablespace?
Why we use bulk collect in oracle?
what is the difference between functional dependecy and multilevel dependency?
List the various oracle database objects?
What privilege is needed for a user to create indexes in oracle?
Why cursor variables are easier to use than cursors?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
can u plz provide me oca sql dumps please i need them
Explain about your project and its relation to the current job position you are applying to?
How do you store pictures in a database?
What are the different types of synonyms?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to see free space of each tablespace?
What are the ways tablespaces can be managed and how do they differ?
How to use like conditions in oracle?
