Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212300 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 / sunil upadhyay
the basic difference is that primary key can not have null
value whereas Unique key can have null values.two null
value are not same.One table may have more than one Unique
Key Constraint
columns, but should have only one Primary Key Constraint
column.
| Is This Answer Correct ? | 88 Yes | 51 No |
Post New Answer View All Answers
Can you tell me how to add new column in existing views?how?How is possible?
Can we insert data in view oracle?
How data locks are respected in oracle?
How many types of tables supported by oracle?
What happens if you lost a data file?
What is an Oracle index?
What are a collation and state the different types of collation sensitivity?
How to invoke the original export import utilities?
Is oracle a relational database?
What exactly do quotation marks around the table name do?
What is BBED in Oracle?
How does oracle handle read consistency?
How to enter a new row into a table interactively?
Write a trigger example in oracle?
How many types of cluster table in Oracle?
