Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between "Primary key" and "Unique key"?
- 4 Answers
- 9313 Views
- PreVator, I also Faced
- E-Mail Answers
Answer Posted / nitin gupta
Uniques: Enforce unique data in the database
it allows row containing null value but only once
It implements non clustered index.
primary key: Enforce unique data in the database
it don't allow any record containing null value
it implements clustered index (data physically
sorted)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between left outer join and left join?
Is nosql faster than sql?
What are dml commands?
How do you delete data from a table?
How to avoid using cursors?
What is the difference between mdf and ndf files?
What is offset and limit in sql?
Why is there a need for sqlcode and sqlerrm variables?
How do you exit in sql?
What is vector point function?
Can you selectively load only those records that you need? : aql loader
How to install oracle sql developer?
How many row comparison operators are used while working with a subquery?
What are the qualities of 2nf?
What are the sql versions?
