Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116011 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
How does a profiler work?
What is normalization and denormalization in sql server?
How to backup encryption key ?
What is subreport?
How do you create a data source?
In case you have filters in your report, when filters will be applied in cached report instance?
Explain what is scheduled job and how to create it?
Can two tables share a primary key?
What is the recovery model?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Name three of the features managed by the surface area configuration tool? : sql server security
Why is the need for data conversion transformations?
how will add additional conditions in sql?
Can foreign key be duplicate?
