Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210341 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 are the attributes of the cursor?
What is oracle update statement with inner join ?
How to update values on multiple rows in oracle?
What is catalog in Oracle?
How to increment dates by 1 in oracle?
What do you understand by database schema and what does it hold?
Explain enable novalidate constraint.
How to connect to oracle using service name instead of sid?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to convert times to characters in oracle?
Whether any commands are used for months calculation? If so, what are they?
Design database draw er diagram for a certain scenario ?
Explain what are clusters?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How many anonymous blocks can be defined?
