what is difference between candidate key and alternate key

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi I want to know how API gravity has been come up with in Oil Industry, especially figures in the following formula: API=(141.5/SG)-131.5

1646


WHAT IS THE DIff Between candidate key and primary key?

1413


write a c program which accept input as:Anu.B.Kapur and give out as:Kapur.A.B using pointers

1281


What are the duties of QA/QC Coordinator

2707


gsm features

1381






difference between a for loop and a while loop? what are its uses in c language?

1552


WAP in Java to print the format AMIT M I T

1604


sir now i am studying B.Tech final year so now i am eligible for writing group 1 and 2 or not?

1233


Why is it that a single, all – encompassing metric cannot be developed for programme complexity or programme quality?

1521


Can you connect Active Directory to other 3rd-party Directory Services? Name a few options.

1566


what is your career objective?

1592


how we can improve mobile ad,hoc network.

1788


Hi, what is the meaning of DOCUMENTUM,how and what testers have to do with it?

5544


Why does the 'divisibility by 3' rule work?

2632


how to handle errors in fastload?

1654