what are the advantages of primary key over unique+notnull
Answer Posted / soubhagya
When we create a primary key automatically a cluster index
is created on those columns involved in primary key.But
this index not created in unique+not null key, it only
restrict the duplicate values.
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What are the different datatypes available in PL/SQL?
What is set serveroutput on?
Does normalization improve performance?
What is sql injection vulnerability?
How many types of literals are available in pl sql?
what are myisam tables? : Sql dba
What is the sql*loader? : aql loader
What is java sql drivermanager?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
what is msql? : Sql dba
What is a unique constraint?
What does subquery mean in sql?
Explain alias in sql?
What is clustered index in sql?
What is the difference between subquery and correlated query?