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

Explain the use of assign statement in progress database?

964


What is meant by a database?

1054


What are the benefits of database management system?

1089


What is openedge abl in terms of taking the perspective of the developer?

970


What is data model in database?

943


What are indexes? What are b-trees?

1058


How to disconnect the user connection?

938


Explain the syntax of named procedure?

1041


What are five types of database models?

950


Enlist the various transaction phases.

1102


Which free database is best?

913


Why is rdbms important?

929


What is dbms with example?

1111


What are the lock types?

1022


How to debug stored procedures?

1025