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 are the extra roles available in msdb? : sql server security
Explain features and concepts of analysis services?
What is catalog views?
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
Explain different types of lock modes in sql server 2000?
Explain what are the authentication modes in sql server?
What are user-defined functions (udfs) in sql server?
What is an identity column in insert statements?
User wants only to display only pdf as export option in report manager. How to achieve this?
What is 1nf normalization form?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
Do you know concepts and capabilities of sql server?
How does using a separate hard drive for several database objects improves performance right away?
What is a data source or ds? : sql server analysis services, ssas
How to find out the list schema name and table name for the database?