Difference between primary key and unique key ?
- 77 Answers
- 198160 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 / mareeswaran-jeyakani
The primary key cannot be accept the null values.The unique key can accept null values. assume that you have a two
columns column1 having primary key constraint and column2 having unique constraint if u try to insert null into column2 it will accept that values whereas column1 will not accept the null values.
THANK YOU.ALL THE BEST...............
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Is postgres faster than oracle?
Explain implicit cursor.
What is private procedure oracle?
Explain integrity constraint?
Explain the use of file option in exp command.
How to unlock the sample user account in oracle?
What is a read only transaction in oracle?
What do you mean by merge in oracle?
Explain the function of optimizer in oracle?
What are the various constraints used in oracle?
How to assign data of the deleted row to variables?
What is oracle server autotrace in oracle?
How to use subqueries with the exists operator in oracle?
Can we create trigger on materialized view in oracle?
Explain about integrity constraint?
