Define candidate key, alternate key, composite key.
- 13 Answers
- 113551 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
Tell me what is difference between clustered and non clustered index?
how we use window authentication connection with sql server.?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is transaction server distributed transaction?
Which database stores information about replication?
What are null values in ms sql server?
Explain about system stored procedure?
How to send email from database?
How to declare and use cursor variables?
how many clustered indexes can be created on a table? : Sql server database administration
How to replace null values in expressions using isnull()?
Write down the syntax and an example for create, rename and delete index?
Can we do dml on views?
What is the importance of a recovery model?
how to create a scrollable cursor with the scroll option? : Sql server database administration
