Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207430 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 do I limit the number of oracle database connections generated by weblogic server?
Use of an integrity constraint is better to validate data. Explain
Write a trigger example in oracle?
How to test null values?
What is difference between sid and service name in oracle?
Explain what are the type of synonyms?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Will you be able to store pictures in the database?explain.
How to turn on or off recycle bin for the instance?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to use like conditions in oracle?
Design database draw er diagram for a certain scenario ?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is the relation of a user account and a schema in oracle?
When do we use group by clause in a sql query?
