Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210319 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 do database buffers contain?
What is a oracle database?
What are the advantages of oracle 12c?
Explain oracle data types with examples?
What is a select query statement in oracle?
Can we save images in a database and if yes, how?
How to create a table index in oracle?
What is open database communication (odbc) in oracle?
What is oracle latest version?
How to find the duplicate rows count from employees table in oracle?
What is a trigger and what are its types?
Does oracle database need java?
How to create a stored program unit?
State all possible different index configurations a table can possibly have?
How will you identify oracle database software release?
