Define candidate key, alternate key, composite key.

Answer Posted / anvar shadath.a

Candidate key: If any unique data column(s)in table is
called candidate key. may be one or more unique data column
(s).We can select any one unique (candidate key column) as
a primary key.

Alternate key: If one table contains more then one
candidate keys, remining candidate keys column(s) which is
not selected as a primary key is called Alternate Key.

Composite key: One primary key Contains more then one
columns is called Composite key.

Is This Answer Correct ?    75 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is log cache in sql server?

498


Do you know what is bit data type and whats the information that can be stored inside a bit column?

528


What is etl - extraction, transformation, and loading?

505


What are parameterized reports?

156


Why are sql functions used?

597






How to compare the top two records using sql?

732


How to defragment table indexes?

529


How do I find the sql server database version?

504


why would you call update statistics? : Sql server database administration

542


What is triggers in ms sql server?

618


What are the reporting services components?

90


What is a non clustered primary key?

486


Difference between primary key and clustered index?

480


What do you mean by normalisation?

483


How check triggers in sql server?

499