what is difference between candidate key and alternate key
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what we have to say about hobbies,strong points,weak points
what is the channel capacity of a band-limited gaussian channel? is it is blog2(1+s/n) or not? if not what?
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
What is VAT Account determination ? and how we can map in SAP ?
safety valve calculation?
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
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?
sample sbi questions paper
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?
how to configure cisco router & switches plz provide me path steps?
steam turbine working and pressure?
Civil Engineering (5086)
Mechanical Engineering (4456)
Electrical Engineering (16639)
Electronics Communications (3918)
Chemical Engineering (1095)
Aeronautical Engineering (239)
Bio Engineering (96)
Metallurgy (361)
Industrial Engineering (259)
Instrumentation (3014)
Automobile Engineering (332)
Mechatronics Engineering (97)
Marine Engineering (124)
Power Plant Engineering (172)
Textile Engineering (575)
Production Engineering (25)
Satellite Systems Engineering (106)
Engineering AllOther (1379)