Difference between primary key and unique key ?
- 77 Answers
- 190718 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 / mohan singh
Primary key contain non repetitive value and not null
value,and primary key is created on clustered index.In the
table their should be one primary key column.
Unique key contain non repetitive value but can contain
only one null value in the column.And unique key is created
on non clustered index.
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What is the use of oracle?
what is dynamic SGA and static SGA
What does sharding mean?
How do we get field detail of a table?
What is the difference between $oracle_base and $oracle_home?
how to do daily transactions with out sql* loader control file regesterd in apps?
how to join query for one source type is oracle another source type is sql server ?
What is not equal to in oracle?
When do you get a .pll extension in oracle? Explain its importance
How to call a sub procedure?
What is oracle in java?
How to list all tables in your schema?
How to start your 10g xe server from command line?
What is java oracle used for?
Can I create users through internet explorer in oracle 10g?
