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
What are different types of collation sensitivity?
What is clustered primary key?
How to deploy the Report?
Why people hate cursor?
What does sql server mean?
What is hot add cpu in sql server 2008?
What happens if null values are involved in arithmetic operations?
What are the dmvs? : sql server database administration
What are truncate options available in sql server? : sql server database administration
How can a database be repaired?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is a coalesce function?
What is the tcp/ip port on which sql server runs?
Can a function call a stored procedure in sql server?
How many columns can exist together per table?