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 difference between candidate key and alternate key

Answers were Sorted based on User's Feedback



what is difference between candidate key and alternate key..

Answer / umer bhat

Any attribute (or set of attributes) that uniquely
identifies a row in a table is a candidate key for primary
key. Such an attribute is called a candidate key. One of
the candidate keys is chosen to be the primary key, based
on the familarity and greater usage. Any attribute that is
a candidate key for the primary key but is not the primary
key is called the Alternate key. When the key uniquely
identifies the row of the table is made than one attribute,
it is called a Composite key.

Is This Answer Correct ?    15 Yes 8 No

what is difference between candidate key and alternate key..

Answer / burhan mughal

All candidate keys which are not chosen as "primary key"
are Alternate keys. The key which uniquely identify the
rows of the table and which is made up of more than one
attribute is called Composite key. Generally a candidate
key becomes the primary key of the table. If the table has
more than one candidate key, one of them will become the
primary key, and the rest are called alternate keys.

Is This Answer Correct ?    11 Yes 8 No

what is difference between candidate key and alternate key..

Answer / bidut karki

Candidate key is a key that works as to uniquely define a record by combination of all attribute inside a table.
However, A candidate key that is not a primary key is called an Alternate key.

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More Engineering AllOther Interview Questions

what is putchar() and getchar()?????

1 Answers  


what is the definition(body) of a default constructor in c++?

0 Answers  


Please send me Sample papers National Informatics Centre (NIC) Programmer. I am giving this paper first time..so if any one have previous question papers send to manoj200.yadav@gmail.com. thnx in advance

0 Answers   NIC,


Derive the equation that links voltage, charge and capacitance.

0 Answers  


BEL old probationary engineering questions and answers

0 Answers   BEL,


write a c programme to count the characters words and lines in a text book

0 Answers  


i m doing my 3rd yr with only 6 month left to complete it..within this 6 months which is the best nd useful oracle certification program should i do??pls help me out!!

0 Answers  


how to implement spiral model on railway reservation?.

1 Answers  


Reverse the link list without creating new list ?

0 Answers  


ABOUT US We, the Meritas Team, is a group of committed and hardworking professional techies, trainers and business consultants. We create, improvise and adapt the best practices in training industry to help our students to standout in the job market to get placed fast. Once a student joins with us, we impart the best possible technical real-time training. Along with that we give utmost care to groom his/her communication, leadership, interpersonal and language skills. We have a committed team of professional HR professionals to help our students to find their dream jobs as soon as they finish their courses.

1 Answers   Meritas,


find the salary of an employee where employee number is known

0 Answers  


I want old SBI question papers plzzzzzzzzz

0 Answers  


Categories
  • Civil Engineering Interview Questions Civil Engineering (5086)
  • Mechanical Engineering Interview Questions Mechanical Engineering (4456)
  • Electrical Engineering Interview Questions Electrical Engineering (16639)
  • Electronics Communications Interview Questions Electronics Communications (3918)
  • Chemical Engineering Interview Questions Chemical Engineering (1095)
  • Aeronautical Engineering Interview Questions Aeronautical Engineering (239)
  • Bio Engineering Interview Questions Bio Engineering (96)
  • Metallurgy Interview Questions Metallurgy (361)
  • Industrial Engineering Interview Questions Industrial Engineering (259)
  • Instrumentation Interview Questions Instrumentation (3014)
  • Automobile Engineering Interview Questions Automobile Engineering (332)
  • Mechatronics Engineering Interview Questions Mechatronics Engineering (97)
  • Marine Engineering Interview Questions Marine Engineering (124)
  • Power Plant Engineering Interview Questions Power Plant Engineering (172)
  • Textile Engineering Interview Questions Textile Engineering (575)
  • Production Engineering Interview Questions Production Engineering (25)
  • Satellite Systems Engineering Interview Questions Satellite Systems Engineering (106)
  • Engineering AllOther Interview Questions Engineering AllOther (1379)