Define candidate key, alternate key, composite key.
Answer Posted / jeevan kurmi
A candidate key is a combination of attributes that can be uniquely used to identify a database record without any extraneous data. Each table may have one or more candidate keys. One of these candidate keys is selected as the table primary key.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is difference between line feed ( ) and carriage return ( )?
How can I tell if sql server is 32 or 64 bit?
What are the advantages to use stored procedures?
How can we solve concurrency problems?
Explain what are various ways to enhance the ssrs report?
Do you know what is difference between stored procedure and user defined function?
Why do we use non clustered index?
How do I view views in sql server?
What are constraints?
What are the types of table?
What are the 2 types of classifications of constraints in the sql server?
Explain what are the restrictions while creating batches in sql server?
How to execute the cursor queries with "open" statements?
What do you understand by sql server agent?
What is the difference between the 2 operating modes of database mirroring?