Difference between primary key and unique key ?
- 77 Answers
- 190843 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
What are the different oracle database objects?
How to count groups returned with the group by clause in oracle?
How to create an oracle database manually?
How do we display rows from the table without duplicates?
Which is better Oracle or MS SQL? Why?
Is insert autocommit in oracle?
Give the advantages and disadvantages of clusters.
How view is different from a table?
What happens if variable names collide with table/column names?
Name the various constraints used in oracle?
How to invoke the original export import utilities?
Explain joins in oracle?
What is a nvl function? How can it be used?
What is the difference between a hot backup and a cold backup in oracle?
What is a proxy class?
