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 is saturation point?
What is sanity testing..please explain with examples
discus the worst and best case complexity of binary search
discuss the conditional formatting and advanced filtering features in MS-Excel with suitable example
0 Answers Punjab Computer College,
hi, i m ganesh.. i have cleared LAKSHMI VILAS BANK FOR clerical post... any body who have already received interview call letter pl mail me to my mail id ganesh_280574@rediffmail.com my mobile no is 9842648112
Hi,am being graduated as BE in MECHATRONICS engineering and now experienced work in mechanical stream for 1.5 years.If am trying for a job in mechatronics what are the fields do i need to be known well and is there any companys who requires a MECHATRONICS ENGINEER.
what happens if an error occurs in constructor or destructor.
different types of protocols.......?
I have done BE ( computer science) i secleted in sbi clerical written exam. so what questions they asked according to my subject please send me the answer
0 Answers State Bank Of India SBI,
What is your Job Profile in IT feild.
how to find out the name of the users who are currently working starting with the same characters in unix os
Give a brief description of the following terms: a) Play head b) Symbol c) Tweening d) ActionScript e) Frame rate f) Library panel g) Masking h) Context – sensitive Property Inspector i) Bandwidth Profiler j) Frame Label