Define candidate key, alternate key, composite key.

Answer Posted / sunil choudhary "hanumangarh"(

candidate key is a single key of each tuple.
alternative key is secondary key . for example(A entity
STUDENT an attribute of NAME,CLASS,ROLL.ID)the roll no is
primary key but id is alternate key.

A key formed combined of to or more columns called comosite
key.

Is This Answer Correct ?    88 Yes 71 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by data manipulation language?

577


How to create an inline table-valued function?

523


what are constraints? : Sql server database administration

509


What do you mean by sql server agent?

524


What is the user of Primary key?

571






Are all views updatable ?

713


How can you check the level of fragmentation on a table?

599


What is the default value of an integer data type in sql server 2005?

572


What do you understand by the analysis services in sql server?

525


Explain filtered indexes benefits?

584


What is the difference between migration and upgradation in sql server?

595


What is the difference between update lock and exclusive lock?

485


Define indexes?

591


How to Check if table exists in sql server?

608


What is dml command?

534