Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210064 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 / susil kumar rout
When we applied primary key constraint upon a column of a table internally oracle create a cluster index.In case of unique constraint,oracle create a non-cluster index.
In a table or entity one primary key and one or more than one
unique key can be applied.
We can't insert duplicate value or null value to primary key
column where as null value can insert into unique key column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain oracle insert into command?
What is the use of oracle?
When do you get a .pll extension in oracle? Explain its importance
What is the difference between online and offline backups?
How to upsert (update or insert into a table)?
What are the different types of trigger and explain its various uses and functions?
What is ceil and floor in oracle?
What are the differences between primary key and unique key?
Explain alias?
How to download oracle database 10g xe?
How to load data through external tables?
What is the order of defining local variables and sub procedures/functions?
Can you create a synonym without having a table?
What do you know about normalization? Explain in detail?
How can I combine multiple rows into a comma-delimited list in oracle?
