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
Can we create a trigger on view?
How do we use distinct statement? What is its use?
Explain the order of sql statement execution?
What is example of database?
What is sql architecture?
what are all the different types of indexes? : Sql dba
Can we change the table name in sql?
Is sql similar to python?
What is substitution variable?
Explain the difference between drop and truncate commands in sql?
Is sql better than access?
What has stored procedures in sql and how we can use it?
What are the different ways to optimize a sql query?
Can we use ddl commands in pl sql?
what is sql in mysql? : Sql dba