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
what's sql server? : Sql server database administration
Do you know the capabilities of cursors?
What is a group function explain with an example?
How do clustered indexes store data?
How to create a new login name in ms sql server?
What do you understand by recursive stored procedure?
What is temporal table?
Explain the microsoft sql server delete command?
what purpose does the model database serve? : Sql server database administration
What is the purpose of the model database?
What happens if we shrink log file in sql server?
How to select true false based on column value in sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are Row versions of DataRow?
What are the parts of a function?