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 sqlservr.exe - process - sql server (sqlex?press)?
What are logical/boolean operations in ms sql server?
How many types of subqueries are there in sql server?
How do I find the sql server instance name?
What is partition, how will you implement it? : sql server analysis services, ssas
Explain comment on transactions?
What stored by the msdb? : sql server database administration
What is the default value of an integer data type in sql server 2005?
What do you understand by sql server agent?
How to delete a login name in ms sql server?
what is a live lock? : Sql server database administration
What is BLOCK statements in SQL?
What do you mean by cardinality?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
When we should use and scope of @@identity?