Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210091 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
Explain the use of record length option in exp command.
Explain alias?
Difference between cartesian join and cross join?
What is the difference between primary key and unique key and foreign key in oracle?
does the query needs a hint to access a materialized view?
What is a directory object?
What is the difference between sharding and partitioning?
What is meant by a deadlock situation?
How to get execution statistics reports on query statements?
Why is oracle used?
What do you understand by a database object?
Explain parameter file in oracle.
How to use attributes of the implicit cursor in oracle?
How do we get field details of a table?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
