Define candidate key, alternate key, composite key.
Answer Posted / swapna
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 ? | 348 Yes | 54 No |
Post New Answer View All Answers
What is mscorsvw.exe - process - microsoft .net framework ngen?
Define full outer join?
what are the reporting service components in SSRS?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain what are various ways to enhance the ssrs report?
Explain logical operators in sql server?
How to loop through returning rows?
What are the purposes and advantages stored procedure?
How can you insert null values in a column while inserting the data?
Which data type columns are the best candidates for full-text indexing?
What is indexed view? How to create it?
How to defragment table indexes?
What stored by the master? : sql server database administration
How can we call UDF(User Define Function) using C# code in ASP.net ?
What are information schema views?