Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212363 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 / pramod paunikar
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a non-clustered index by default. Another
major difference is that, primary key does not allow NULLs,
but unique key allows only one NULL only.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is bind variable in oracle 11g?
Explain the different normalization forms?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What is a sub query? What are its various types?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Who developed oracle & when?
types of indexes and the rationale behind choosing a particular index for a situation.
What is meant by an index?
How do I reset a sequence in oracle?
What is private procedure oracle?
Why do we use coalesce function in oracle?
What is oracle in java?
What is the scope of a local variable?
Explain the use of record option in exp command.
