Define candidate key, alternate key, composite key.
Answer Posted / sunil choudhary "hanumangarh"(
candidate key is a single key of each tuple.
alternative key is secondary key . for example(A entity
STUDENT an attribute of NAME,CLASS,ROLL.ID)the roll no is
primary key but id is alternate key.
A key formed combined of to or more columns called comosite
key.
Is This Answer Correct ? | 88 Yes | 71 No |
Post New Answer View All Answers
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is the difference between locking and multi-versioning?
What is difference between inner join and full join?
How to replace given values with null using nullif()?
What are dml (data manipulation language) statements in ms sql server?
How does clustered and non clustered index work?
why would you use sql agent? : Sql server database administration
How to create a simple stored procedure in ms sql server?
What is the cartesian product of the table?
Explain the concept of recursive stored procedure.
What is user-defined scalar function?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Do you know what are the restrictions that views have to follow?
How will you monitor replication latency in transactional replication? : sql server replication
What are the different types of sub-queries?