Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115971 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 service broker?
When you should use a low fill factor?
How many databases Microsoft SQL server provides?
What is the exact numeric data type in sql?
Define a cross join?
Explain the properties of sub-query in sql server?
How to list all columns in a table using odbc_columns()?
What are the extra roles available in msdb? : sql server security
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What are the dmvs? : sql server database administration
What do you understand by coalesce in sql server?
In what version of sql server were synonyms released?
List out the differences between the clustered index and non-clustered index in sql server?
Why use “nolock” in sql server?
How do I view views in sql server?
