Define candidate key, alternate key, composite key.
- 13 Answers
- 113512 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
What are the different types of upgrades that can be performed in sql server?
What are some examples of schemas?
What is the difference between lock, block and deadlock? : sql server database administration
Characterize join and name diverse sorts of joins?
what method you can use to reduce the overhead of Reporting Services data sources?
What is a mutating table error and how can you get around it?
Is sql server 2016 free?
How to use the inserted and deleted pseudo tables?
What is self join in sql server joins?
How can you hide the sql server instances?
Explain the properties of a relational table?
Explain the collation?
What are points to remember while using the fillfactor argument?
What is the purpose of optimization?
Explain how to use linked server?
