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 you can get the list of largest tables in a database?
Define ACID properties in a Database?
Why we need to use secondry database file? though, we can do same work using primary database file also.
How to use order by with union operators in ms sql server?
Explain different forms of normalization?
What is filestream?
What is scrollable cursor?
What does Master database contains?
What are data regions?
Do you know what is difference between index seek vs. Index scan?
How many ways to create table-valued functions?
What are the different types of collation sensitivity in sql server?
What is the difference between a check constraint and a rule?
What is indexing explain it with an example?
how you can get the list of largest tables in a database? : Sql server administration