Difference between primary key and unique key ?
- 77 Answers
- 190697 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
How to define a cusotmer as a supplier in ORACLE R12
How to write date and time literals in oracle?
How to create a table in a specific tablespace?
How do you bind variables in oracle?
What is Virtual Private Database in Oracle?
Explain index?
How to turn on or off recycle bin for the instance?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the usage of synonyms?
Explain what are synonyms used for?
What is oracle server autotrace in oracle?
What privilege is needed for a user to query tables in another schema?
What is program global area (pga) in oracle?
Explain table?
What is a select query statement in oracle?
