Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116495 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / sheharyar ali
Candidate Key
A coulmn in database table that can be used to uniquely identify each row in that table is said to be a Candidate Key
Primary Key
IF a Table has a coulmn or min Combination of Column(s) that can uniquley Identify each Row in that table then such a column or group of Column is said to be Primary Key
Alternate Key
A table may contain more than one Cadidate Column.Among these Candidate column the most appropiate one is genrally chosen as Primary Key While others that are left out are Said to be Alternate Keys.
Composite Key
Combination of more than One Column to uniquely identfiy all rows in a Table is said to be Composite Key
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is system stored procedures?
What is surrogate key? : sql server analysis services, ssas
Who developed sql server?
What are the different types of Indexes available in SQL Server?
Which are the two editions in which SQL Azure database available?
What is an entity-relationship diagram (erd)?
What is tablix?
What is SQL Azure Firewall?
What is the difference between stored procedure and functions?
What is normalization according to you and explain its different levels?
Do you know what is replace and stuff function in sql server?
What is a transactions?
Differentiate between a local and a global temporary table?
What is cursor in ms sql server?
What happens if null values are involved in string operations?
