what are the advantages of primary key over unique+notnull
Answer Posted / charumathi
Unique-Duplicates not allowed
Nulls allowed
Not null-NUlls not allowed
Primary key-No Duplicates
No Nulls
A Foriegn key can refer to the primary key.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
Is sql considered coding?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
Is sql sequential or random?
Which is the correct statement about truncate and delete?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Can unique keys be null?
What do you mean by table in sql?
Is sql better than excel?
How many functions are there in sql?
Why are cursors used?
how many groups of data types? : Sql dba
Is inner join faster than left join?
What is embedded sql in db2?
How to disable a trigger name update_salary?
what is a composite primary key ? : Sql dba