Define candidate key, alternate key, composite key.
- 13 Answers
- 111433 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 CTE in SQL
What is indexing in sql server with example?
What do you think of this implementation? Can this be implemented better?
What is model database? : SQL Server Architecture
Explain the cursor lock types?
What is the sql profiler?
Can you move the resources after pausing the node? : sql server database administration
What is the sql case statement used for? Explain with an example?
Does sql server 2000 clustering support load balancing?
Why would you use sql agent?
Do you know what is user defined datatypes and when you should go for them?
What is indexing explain it with an example?
How to transfer a table from one schema to another?
Difference between Inner vs outer joins?
How to find the second highest salary of an employee?
