Define candidate key, alternate key, composite key.
- 13 Answers
- 111422 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / amar
A candidate key is one that can identify each row of a
table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys. A key formed by
combining at least two or more columns is called composite
key.
| Is This Answer Correct ? | 42 Yes | 14 No |
Post New Answer View All Answers
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is shrink log file?
What is check constraint in sql server?
What is report rendering ?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is always encrypted?
what is create database syntax? : Sql server database administration
Explain what is meant by replication of database?
How do you delete duplicate records in sql server?
What is the difference between locking and multi-versioning?
List out some of the requirements to set up a sql server failover cluster?
What is @@rowcount in sql?
Explain acid?
When would you use it?
What is etl - extraction, transformation, and loading?
