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
What is log cache in sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is etl - extraction, transformation, and loading?
What are parameterized reports?
Why are sql functions used?
How to compare the top two records using sql?
How to defragment table indexes?
How do I find the sql server database version?
why would you call update statistics? : Sql server database administration
What is triggers in ms sql server?
What are the reporting services components?
What is a non clustered primary key?
Difference between primary key and clustered index?
What do you mean by normalisation?
How check triggers in sql server?