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 are the steps you should follow to start sql server in single-user mode?
How to use wildcard characters in like operations in ms sql server?
Which are the third-party tools used in sql server and why would you use them?
What is normalization 1nf 2nf 3nf?
Is candidate a key?
Define ACID properties in a Database?
How to find the list of fixed hard drive and free space on server?
Can you force a query to use a specific index?
How to find table changes in sql server?
What command is used to delete a table from the database in the sql server and how?
What are the benefits of normalization?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to add more data to the testing table in ms sql server?
what kind of lan types do you know? : Sql server database administration
How to find the second highest salary of an employee?