Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 208097 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 / tom
There is two difference between them.
1. The not null constraint is by default added to primary
key, it means, primary key attribute cannot accept null
values, whereas, the attribute declared as unique can accept
null values. It is the major difference between the two.
2. Secondly, we can have only one primary key in a relation,
whereas, multiple attributes can be declared unique at the
same time.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to login to the server without an instance?
What are advantages of dateset in datastage?
What are the arithmetic operations?
What are group functions in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to return top 5 rows in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Explain the use of online redo log files in oracle.
How to write numeric literals in oracle?
What is analyze command used for?
Is postgres faster than oracle?
How to assign values to variables?
What is using clause and give example?
