Define candidate key, alternate key, composite key.
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
Can sql servers link to other servers?
How to insert data with null values?
What are the functions in sql server?
What are the different types of backups avaialabe in sql server 2005?
What is the difference between varchar and varchar types?
What is subquery? Explain the properties of a subquery?
How to find the service pack installed? : sql server database administration
What is use of @@ spid in sql server?
What the different topologies in which replication can be configured?
How to provide default values to function parameters?
Why Master database is required?
What is a schema in ms sql server 2005?
What are cascading parameters in ssrs reports?
What is the language structure to add a record to a table?
Is foreign key unique?