Define candidate key, alternate key, composite key.

Answer Posted / jeevan kurmi

A candidate key is a combination of attributes that can be uniquely used to identify a database record without any extraneous data. Each table may have one or more candidate keys. One of these candidate keys is selected as the table primary key.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between line feed ( ) and carriage return ( )?

528


How can I tell if sql server is 32 or 64 bit?

501


What are the advantages to use stored procedures?

573


How can we solve concurrency problems?

574


Explain what are various ways to enhance the ssrs report?

573






Do you know what is difference between stored procedure and user defined function?

616


Why do we use non clustered index?

555


How do I view views in sql server?

522


What are constraints?

592


What are the types of table?

549


What are the 2 types of classifications of constraints in the sql server?

592


Explain what are the restrictions while creating batches in sql server?

591


How to execute the cursor queries with "open" statements?

616


What do you understand by sql server agent?

536


What is the difference between the 2 operating modes of database mirroring?

579