Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115531 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 to define output parameters in stored procedures?
what is the sql equivaent of the dataset relation object ?
What is pessimistic concurrency?
What is the difference between Stored Procedures and triggers?
Name few endpoints exposed by ssrs 2012?
What are the new features are introduced in sql server 2012 reporting services?
How does recursive cte works in sql server?
How connect excel to sql server?
What is Replication?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Which are the important points to note when multilanguage data is stored in a table?
Tell me what is the difference between locking and multi-versioning?
Is truncate autocommit?
Explain the dirty pages?
Why olap is used?
