Define candidate key, alternate key, composite key.
- 13 Answers
- 113510 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
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 are extended events in sql server?
How do I view a trc file?
How to create a ddl trigger using "create trigger" statements?
Can primary key be null?
What are the different types of backups avaialabe in sql server 2005?
What is data compression? : sql server database administration
Explain what is public role in sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is difference between materialized view and view?
Explain nested trigger in sql?
How do I schedule a sql server profiler trace?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Can a table be created inside a trigger?
How to download and install the scaled-down database adventureworkslt?
What is rolap and its advantage? : sql server analysis services, ssas
