Define candidate key, alternate key, composite key.
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 a transact-sql statement?
Explain linked server in sql?
What is single-user mode?
What is store procedure?
Can a table be created inside a trigger?
In what sequence sql statement is processed?
Why use “in” clause in sql server?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How to filter records of table in SQL SERVER?
What is the difference between mysql and mysqli?
How to rebuild all indexes on a single table?
Does a server store data?
What is ssrs?
How to get the definition of a trigger back?
What are different types of table joins?