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
what is collation? : Sql dba
Name the different types of indexes in sql and define them.
what is a primary key? : Sql dba
What is a variable in sql?
What do you think about pl/sql?
How does an execution block start and end in pl sql?
What is information schema in sql?
What does pl sql stand for?
What does over partition by mean in sql?
what is a cursor? : Sql dba
What is a parameter query?
What is the difference between an inner and outer join?
what are wild cards used in database for pattern matching ? : Sql dba
Define a temp table?
What are the different sql commands?