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
What do you mean by data manipulation language?
How to create an inline table-valued function?
what are constraints? : Sql server database administration
What do you mean by sql server agent?
What is the user of Primary key?
Are all views updatable ?
How can you check the level of fragmentation on a table?
What is the default value of an integer data type in sql server 2005?
What do you understand by the analysis services in sql server?
Explain filtered indexes benefits?
What is the difference between migration and upgradation in sql server?
What is the difference between update lock and exclusive lock?
Define indexes?
How to Check if table exists in sql server?
What is dml command?