what is difference between candidate key and alternate key

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the work of Loopback ?

1432


Modal vs Modaless in VB??

1513


Give the coding for system reboot in C

1424


Please explain why you are suitable for the position that you have applied for?

1618


WHY SHOULD I HIRE YOU

1538






what is a Additional domain ? what is a child domain?

2366


WHAT IS THE NAMESPACE FOR CUSTOMCONTROL AND USER CONTROL IN ASP.NET?

1668


what is rapid application development

1296


Please send me Sample papers OF National Informatics Centre (NIC) Vacency

1679


how to cable size by Amp with example

2191


Explain power?

878


why this for loop doesn't work . int i; for(i=2;i=0;i--) { cout<

1456


What is the difference between tcp/ip protocol and IP protocol?

1802


can any give an exact example about, resolving the sql errorcode -305

1466


What are the main differences between the engines in jet fighters and the engines in jet airliners; which type of engine is the more efficient, and (qualitatively) why?

697