Define candidate key, alternate key, composite key.
- 13 Answers
- 113567 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
Will the writetext statement activate a trigger?
Can you explain what is indexed view? How to create it?
What does truncate do?
How do I completely remove sql server instance?
What happens if null values are involved in boolean operations?
What is the user of Primary key?
What will be the maximum number of index per table?
Can you explain different types of locks in sql server?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Create and insert into temp table in sql server?
What is the tcp/ip port on which sql server runs?
If a table does not have a unique index, can a cursor be opened on it?
What is difference between views and stored procedures?
How do I connect to sql server database?
What is the use of commit?
