Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the difference between a delete command and truncate command?

980


what are the different kinds of indexing?

1015


What is a form used for in a database?

920


Is database a storage?

903


What is database management system(dbms)?

993


What are the applications of database management system?

891


What is difference between database and schema?

995


What is executive plan?

917


What is flag in database?

1015


Is there an example how to configure externalfileaccess setting in firebird.conf?

962


What is the e-r model?

881


What is tuple and attribute?

937


Can you explain the select into statement?

1031


What is database optimization?

959


What do you mean by Correlated subquery in database?

999