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
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What are different types of collation sensitivity?
Does a sql server 2005 select statement require a from?
Will the writetext statement activate a trigger?
What are sparse columns?
How to check table values in sql server?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Are semicolons required at the end of sql statements in sql server 2005?
Distinguish between commit and rollback?
What is transact-sql ddl trigger?
What is query parameter in ssrs?
What is a performance monitor?
what are different types of backups available in sql server? : Sql server database administration
How is a full-text index updated?
How to get a list all databases on the sql server?