Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210083 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
How to update values in a table in oracle?
How can you use check constraints for self referential integrity?
How to check database size in Oracle?
What are ddl statements in oracle?
How do we get field detail of a table?
What is difference between truncate and delete?
Explain the difference between sql and oracle?
What are the limitations of check constraint?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain an index?
How to create a testing table in oracle?
What privilege is needed for a user to create views in oracle?
How to use "in out" parameter properly?
How can I create database in oracle?
How to delete multiple rows from a table in oracle?
