Define candidate key, alternate key, composite key.
Answer Posted / jeevan kurmi
A candidate key is a combination of attributes that can be uniquely used to identify a database record without any extraneous data. Each table may have one or more candidate keys. One of these candidate keys is selected as the table primary key.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the sql case statement used for?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Does group by sort data?
How do I install only the client tools of sql server 2000?
What are exact numeric data types in ms sql server?
How can we remove orphan records from a table?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How to Insert multiple rows with a single insert statement?
What are audit control procedures?
Explain the microsoft sql server delete command? : SQL Server Architecture
What is read uncmmited?
How to change the password of a login name in ms sql server?
What is extended stored procedures?
Define Business Edition in SQL Azure?
What is a print index?