Define candidate key, alternate key, composite key.
Answer Posted / amar
A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys. A key formed by
combining at least two or more columns is called composite
key.
| Is This Answer Correct ? | 42 Yes | 14 No |
Post New Answer View All Answers
What is acid properties?
Can you type more than one query in the query editor screen at the same time?
Explain about builtinadministrator?
Why we need sql server?
What is it’s similarity with sql server?
What is difference between view and materialized view?
What are the types of normalization?
What is lock escalation? : sql server database administration
What is normalization and what are the advantages of it?
What is raiseerror? What is raiseerror?
How to convert numeric expression data types by assignment operations?
Why union all is faster than union?
What is the difference between delete and truncate statements?
How to delete duplicate rows from table except one?
What are parameterized reports?