Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207612 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 privilege is needed for a user to create indexes in oracle?
Why packages are used in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is the relationship among database, tablespace and data file?
What are the original export and import utilities?
What are the limitations of check constraint?
What privilege is needed for a user to delete rows from tables in another schema?
Explain what are synonyms used for?
What privilege is needed for a user to query tables in another schema?
What are the tools for Oracle ?
How to create an oracle database manually?
How to get a list of all user accounts in the database?
State some uses of redo log files?
Explain a private synonyms?
How to generate query output in html format?
