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 |
write a program to accept 25 characters and at the end display the largest and smallest among them.
is the meter head is same as back pressure?
How to defaultly populate charges in Clear transactions window for Cash Management?
i possess a little knowledge of core java . so is it will be difficult for me to start advanced java?
hey,,,hi have taken an emergency date of 21st july...i was continuously checking for dates n i was not able to get a normal date n my school is starting from 8th of september...so plz tell me can i get a rejection based on this, that i have taken an emergency date?????
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.
what are the examples of E-Based Applications?
today apptitude questions
hello everyone, one thing thats giving me a headache..hope u guys will help me out.i recently gave my gre and got extremely low marks. my gre score is 980 , enginnering aggregate is 58% , diploma aggregate is 73% , 10th score is 79%.so d big question is , is der any possibility of getting admission in any average US university ? am in a turmoil, Please help me out.Thanks in advance
Why is not creat swap partition in my system.
explain in detail about life cycle of thread
What have you done to improve or develop your knowledge / professional qualifications in the last year?
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)