Difference between primary key and unique key ?
- 77 Answers
- 199470 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
candidate key is subset of super key but not vice-verse explain
Explain the use of show option in imp command.
What are operators in oracle?
How to open and close an explicit cursor in oracle?
how to clone 9i Database on to 10g Database.
How to create id with auto_increment on oracle?
How do I call oracle stored procedures that take no parameters?
What is object data modeling?
what is IDE,DMV in sql server?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Is truncate autocommit in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What are transaction isolation levels supported by oracle?
Explain the importance of .pll extension in oracle?
How to create tables for odbc connection testing?
