Difference between primary key and unique key ?
- 77 Answers
- 198289 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
How to count groups returned with the group by clause in oracle?
Please explain oracle data types with examples?
What's dateware house and what's clustor with practicle example
Explain how you would restore a database using RMAN to Point in Time?
Explain what are the characteristics of data files?
What is an oracle user account?
Will you be able to store pictures in the database?explain.
Describe the types of sub query?
Explain the use of grant option in exp command.
What privilege is needed for a user to create views in oracle?
How can we find out the current date and time in oracle?
How to execute the package in oracle?
What are the types of partitions in oracle?
what are the default admin accounts in Oracle 10g ?
How do I uninstall oracle 11g?
