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 sql? : Sql dba
Explain the commit statement.
What language is oracle sql developer?
How would you pass hints to the sql processor?
what is a database lock ? : Sql dba
What do you understand by case manipulation functions?
Explain the uses of database trigger.
What are string functions in sql?
List the various privileges that a user can grant to another user?
How many tables can you join in sql?
Is ms sql is free?
What are stored procedures used for?
Explain the select statement in sql?
How does index help in query performance?
How can triggers be used for the table auditing?