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


Please Help Members By Posting Answers For Below Questions

What are the extra roles available in msdb? : sql server security

845


Explain features and concepts of analysis services?

675


What is catalog views?

796


The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

700


Explain different types of lock modes in sql server 2000?

687






Explain what are the authentication modes in sql server?

678


What are user-defined functions (udfs) in sql server?

731


What is an identity column in insert statements?

745


User wants only to display only pdf as export option in report manager. How to achieve this?

212


What is 1nf normalization form?

741


what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

658


Do you know concepts and capabilities of sql server?

741


How does using a separate hard drive for several database objects improves performance right away?

699


What is a data source or ds? : sql server analysis services, ssas

760


How to find out the list schema name and table name for the database?

709