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
Does truncate release storage space?
What is coalesce sql?
What is the difference between sql and mysql?
What are procedures used for?
Is pl sql better than sql?
How can we find duplicate records in a table?
What is auto increment in sql?
what is sql? : Sql dba
What is scope of pl sql developer in future?
what is user defined functions? : Sql dba
What is the difference between delete, truncate and drop command?
Is sql low level language?
How do I remove sql developer from windows 10?
How bulk collect improves performance?
What are the advantages of normalization?