Define candidate key, alternate key, composite key.
Answer Posted / tanaji
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 ? | 23 Yes | 19 No |
Post New Answer View All Answers
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Explain view in sql server?
What are the underflow and overflow behaviors on float literals?
What are types of scd? : sql server analysis services, ssas
what stored procedure would you use to view lock information? : Sql server administration
Describe how to use the linked server?
What is difference between after and before?
what is the system function to get current user's user id? : Sql server database administration
State the difference between local and global temporary tables?
What is difference in performance between insert top (n) into table and using top with insert?
What is master database? : SQL Server Architecture
What are approximate numeric data types in ms sql server?
Explain cursor as data base object?
How to execute stored procedure in select statement sql server?
What is a rownum?