Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116067 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 a self join in sql server?
How can I create a new template for import ? : sql server management studio
What is subquery explain with example?
What is cdc in sql server?
Explain unique key in sql server?
Explain the difference between HTTP and HTTPS in database?
What are the underflow and overflow behaviors on float literals?
How to test subquery results with the exists operator?
How to change parameter value inside the report?
What purpose does the model database server?
Explain what are various ways to enhance the ssrs report?
Define outer join in sql server joins?
Does group by or order by come first?
How do I install sql server?
Why functions are used in sql server?
