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

How can you perform pattern matching in sql?

1007


How many records can a database hold?

953


Explain a tp monitor?

978


Why are databases so important?

958


What is tuple in rdbms?

1116


Is sql is a dbms?

918


What is data sparsity and how it effect on aggregation?

951


Mention the differences between trigger and stored procedures

1168


what are the two integrity rules used in DBMS?

1126


Is filemaker pro a relational database?

1072


What are service-specific middleware?

1008


Which parameters are optional in init.ora parameter file?

2223


Define ddl and dml.

1050


What does rdbms stand for?

1082


Can you drop all the columns of a table ?

976