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
Explain full-text indexing?
What is sql injection and why is it a problem? : sql server security
How you can add messages to the nt event log from within a stored procedure?
What is the difference between varchar and varchar(max) datatypes?
What are types of storage modes? : sql server analysis services, ssas
What is intellisense?
What are the diifferences between the ms sql server vs mysql?
How can we delete a table in sql server?
Do you know what are the restrictions that views have to follow?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is the cartesian product of table?
Explain the truncate command? : SQL Server Architecture
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Why main is user defined function?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration