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
List some case manipulation functions in sql?
How to handle error or exception in sql?
What is partition in sql server?
Why use “in” clause in sql server?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is the difference between primary key and unique constraints?
What stored by the master?
What is service broker? : sql server database administration
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How to count duplicated values in a column in ms sql server?
how you can configure a running aggregate in SSRS?
Why is sql server log file full?
What are “phantom rows”?
How to modify an existing user defined function?