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 we have to say about hobbies,strong points,weak points

0 Answers   Banking,


what is the channel capacity of a band-limited gaussian channel? is it is blog2(1+s/n) or not? if not what?

3 Answers   UGC NET,


if a customer's blackberry stopped syncing their calendar wirelessly what would you do?if a customber deleted mail from his blackberry but it did delete from his mailbox how would ypu resolve this

0 Answers  


What is VAT Account determination ? and how we can map in SAP ?

0 Answers   TCS,


safety valve calculation?

0 Answers   HEG,


hi friends, i got selected in tcs, i m doing my b.e in one of the college in coimbatore.. i don have questions to post u.. but i have valid suggestion..its waste to prepare apti for tcs by looking at last 10 year question from internet.they changed all the apti question this year(2009).. but apti questions is easy..prepare critical reasoning for gre 12th edition..mug up the answers in critical reasoning.. u can download ebook for gre 12th edition..solve the critical reasoing question at the same time mug up it.. there were totally 3 critical reasoning question asked.. two for gre 12th edition so if u mug up u can finish two questions in 3 min.. so u will have 27 min for other question so u can work it out and find the ans..above i mentioned as 3 questions tat is 3 question means ,three paargraph.. each para carries 4 question so totally 12 question in critical reasoning.. if u clear all 12 question u will be selected.80% percent sure.then don mug up synonyms from gre barron because they are asking same question from barron but the choice for the questions are changed.. so study synonyms and antonyms from internet.. some pupils have posted the questions.. in tech and h r don use complex word or don show tat u r so dminant.. talk with them how u will speak wit ur friend. u will be through.. don think wat i have posted above is lik some info in other site.. wat i said is true.. they changed apti tis time.. u will be selected if u follow wat i said..again i m saying pls concentrate on critical reasoning.. if all questions in it are right u r through..bye

0 Answers  


Q1.What do you mean by static routing and dyanamic routing? Q2.What do you mean by template in c++? Explain. Q3.What do you mean by VSAT in data communication?

1 Answers  


sample sbi questions paper

0 Answers  


Explain the role of a sequence counter in execution of a instruction.

2 Answers   247Customer, Google, WNS,


15. What is your Future Plans for the Company if Permanently Employed?

0 Answers   Siemens,


how to configure cisco router & switches plz provide me path steps?

0 Answers   CMS,


steam turbine working and pressure?

1 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)