what is candidate key & primary key,different b/t the two?
Answer Posted / parijatha
there is no difference between the candidate and primary key
as both derives all other attributes in the relation.The
concept of primary key came into account to make the search
easy the is whenever a candidate key is declared as primary
key the primary key attribute gets sorted which reduces the
response time
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a delete command and truncate command?
what are the different kinds of indexing?
What is a form used for in a database?
Is database a storage?
What is database management system(dbms)?
What are the applications of database management system?
What is difference between database and schema?
What is executive plan?
What is flag in database?
Is there an example how to configure externalfileaccess setting in firebird.conf?
What is the e-r model?
What is tuple and attribute?
Can you explain the select into statement?
What is database optimization?
What do you mean by Correlated subquery in database?