Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210316 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 / manoj routh
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 nonclustered index by default. Another major
difference is that, primary key doesn't allow NULLs, but
unique key allows one NULL only.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to start a new transaction in oracle?
How to do a full database export?
Explain compound trigger in oracle?
How do you tell what your machine name is and what is its IP address?
How to create a testing table in oracle?
Explain oracle 12c new features for developers?
How to define an external table with a text file?
What is merge in oracle?
Explain implicit cursor.
how may join possible between (requisition with purchase order)
What is the difference between PFILE and SPFILE in Oracle?
How many file formats are supported to export data?
How to select an oracle system id (sid)?
What do you mean by merge in oracle and how can we merge two tables?
How to view the tablespaces in the current database?
