Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115530 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / amar
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 ? | 42 Yes | 14 No |
Post New Answer View All Answers
What is difference between inner join and full join?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
How to select true false based on column value in sql server?
Do you know what is difference between index seek vs. Index scan?
How do I run sql server 2014?
List out the differences between the clustered index and non-clustered index in sql server?
What is delete query?
What are the reporting services components?
What are views in ms sql server?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Does transparent data encryption provide encryption when transmitting data across the network?
How do I find the sql server version?
In which sql server version report builder introduced?
What is the difference between function and stored procedure in sql server?
Determine when to use stored procedure to complete sql server tasks?
