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 are the main differences between primary key and unique key?

1038


What do you understand by join?

1187


Which parameters are optional in init.ora parameter file?

2271


What are service-specific middleware?

1064


How rdbms is different from dbms?

946


What is normalization in database with example?

979


What is db driver?

1016


What are the ways to controlling cursor behavior?

1034


What are the functions of rdbms?

1074


What is the most popular database?

985


What do you mean by entity type extension?

1117


Which is the best database?

966


What is query in database?

964


What do you mean by e-r model?

1052


When does checkpoint occur?

930