Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207436 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 list all user accounts in oracle?
What is the difference between alert log file and tarce file ?
What is an oracle user account?
Explain oracle’s server parameter file.
What is the difference between a user and a schema in oracle?
Which is faster join or subquery in oracle?
How does the on-delete-cascade statement work?
What is the usage of control file in oracle?
How to convert characters to dates in oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How remove data files before opening a database?
What is the difference between sharding and partitioning?
Can multiple columns be used in group by in oracle?
How to use subqueries with the in operator using oracle?
How to assign a table row to a record variable?
