Define candidate key, alternate key, composite key.
- 13 Answers
- 113498 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / raghuram
Candidate Key is a Key which identifies each row of a table
uniquely. Generally a Candidate Key becomes a Primary Key
of the table. If table has more than one Candidate Keys
then one is called Primary key and rest are called
Alternative Keys.
A key is formed by two or more columns is called Composite
Keys.
| Is This Answer Correct ? | 80 Yes | 28 No |
Post New Answer View All Answers
What are transactions in sql?
Can a rule be bound to any column of any data type?
What is statement level trigger?
How to integrate the ssrs reports in application?
Can we join two tables without primary key?
How many types of built in functions are there in sql server 2012?
Explain index in sql server?
What is implicit mode in sql server?
How to convert binary strings into integers in ms sql server?
How except clause is differs from not in clause?
What is the maximum number of index per table?
What are filegroups in sql server?
What is change data capture (cdc) feature?
Do you know what is replace and stuff function in sql server?
What is self join in sql server joins?
