Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207497 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 rebuild an index in oracle?
How to change program global area (pga) in oracle?
What are temporal data types in oracle?
How to handle a single quote in oracle sql?
Can we use bind variables in oracle stored procedure?
How to use subqueries with the exists operator in oracle?
Explain the use of full option in exp command.
What is oracle database client?
How to delete multiple rows from a table in oracle?
How to name query output columns in oracle?
How to compare dates in oracle sql?
What is a user account in oracle?
6. Display the client name and order date for all orders using the traditional method.
what are archived logs?
What is the data pump export utility?
