Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210004 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
When system tablespace is created?
How to write a query with a right outer join in oracle?
What are internal user account in oracle?
What is difference between sid and service name in oracle?
Explain the use of show option in imp command.
Explain constraining triggers.
How many types of database triggers exist?
How to view all columns in an existing table?
What are the system predefined user roles?
How does the on-delete-cascade statement work?
What is the purpose of save points in oracle database?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is a tns file?
Explain the use of ignore option in imp command.
Where do you use decode and case statements?
