what are the advantages of primary key over unique+notnull
Answer Posted / kamal
we are able to create a primary key for combination of more
than 1 column. which is not possible in Unique,we should
create unique key for each and every column in the table
individually.
ex . we can create a primary key for (Name,DOB,address)- ie
combination of these three columns be unique.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What are the types of functions in sql?
tell me about various levels of constraint. : Sql dba
when is the use of update_statistics command? : Sql dba
Explain the difference between drop and truncate commands in sql?
what is normalization? : Sql dba
Can we use view in stored procedure?
Explain character-manipulation functions?
What is the difference between view and stored procedure?
What is sqlcommand?
how can we submit a form without a submit button? : Sql dba
What is oracle sql developer?
Explain exception handling in pl/sql?
What if we write return in procedure?
Why coalesce is used in sql?
how to use case expression? : Sql dba