Define candidate key, alternate key, composite key.
Answer Posted / unknown
If for any table, we have more than one primary key, viz If
the table can be uniquely identified by the help of more
than one attribute, the collection is called 'Composite
Key'. If only one key can act as the unique key, it is the
Primary key, rest of the keys are called alternate keys.
Individual keys of the composite key are the candidate keys.
| Is This Answer Correct ? | 18 Yes | 28 No |
Post New Answer View All Answers
Can I save my report as html, excel or word? : sql server management studio
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is service broker? : sql server database administration
How to change a login name in ms sql server?
What is the function of sql server agent windows service?
Is it possible in sql table to have more than one foreign key?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How to attach adventureworkslt physical files to the server?
How can I check that whether automatic statistic update is enabled or not?
How to check table values in sql server?
What are joins in sql and what are the different types of joins?
What is TDS(Tabular Data Stream) Gateway?
Differentiate between a having clause and a where clause.
How do I find the sql server version?
Explain having clause and where clause?