Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212269 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 lock and unlock a user account in oracle?
Explain the difference between replace() and translate() functions in oracle?
What are joins, explain all types of joins?
What is meant by an index?
Is there a function to split a string in plsql?
What is the difference between translate and replace in oracle?
What is oracle rownum?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
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 to resolve name conflicts between variables and columns?
How do we represent comments in oracle?
What is Redo Log Buffer in Oracle?
How to start your 10g xe server from command line?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Can we store pictures in the database and if so, how it can be done?
