Define candidate key, alternate key, composite key.
- 13 Answers
- 111604 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / tanaji
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 ? | 23 Yes | 19 No |
Post New Answer View All Answers
What is the order by used for?
Tell me what are cursors and when they are useful?
What are approximate numeric data types in ms sql server?
What is sql collation?
What is a deadlock and what is a live lock?
How are the unique and primary key constraints different?
What are tables in sql server?
Explain what are the events recorded in a transaction log?
List out the differences between the clustered index and non-clustered index in sql server?
How to create a ddl trigger using "create trigger" statements?
How check triggers in sql server?
What are the different kinds of ssrs reports?
How to scale out a federation by Sql statement?
What is a raid and what are different types of raid configurations?
Explain query editor regions
