Difference between primary key and unique key ?
- 77 Answers
- 197688 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 / niranjan dhungia
Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).
| Is This Answer Correct ? | 1017 Yes | 126 No |
Post New Answer View All Answers
How to use in conditions in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Can we commit inside a function in oracle?
How to filter out duplications in the returning rows using oracle?
How can we find out the current date and time in oracle?
Explain the use of show option in imp command.
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Write a syntax for update query in oracle?
How can we force the database to use the user specified rollback segment?
What is rich query?
How many types of cluster table in Oracle?
How to check the oracle tns settings?
What is java oracle used for?
Can I create users through internet explorer in oracle 10g?
What do you understand by a database object? Can you list a few of them?
