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 merge join?
When I run the sql server 2000 setup, it just hangs. What do I do?
How to identify current user in ssrs report?
List the data types available in mssql?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is cursors? And what are the different types of cursor?
Some queries related to SQL
What is full outer join in sql server joins?
What does nvl stand for?
What are different types of views?
Explain what are page splits? : SQL Server Architecture
How to drop an existing user defined function in ms sql server?
What do you understand by hotfixes and patches in sql server?
What is the difference between the 2 operating modes of database mirroring?
What is the current pricing model of SQL Azure?