what is difference between "Primary key" and "Unique key"?
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 vector point function?
Can we use join in subquery?
Is it important to partition hard disk?
What packages are available to pl/sql developers?
What is the most important ddl statements in sql are?
What is sql*loader and what is it used for?
What are all different types of collation sensitivity?
When is a declare statement required?
what is msql? : Sql dba
What is sql keyword?
What is ttitle and btitle?
What is informix sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is t sql used for?
How can you know that statistics should be updated?