Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115962 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / raghuram
Candidate Key is a Key which identifies each row of a table
uniquely. Generally a Candidate Key becomes a Primary Key
of the table. If table has more than one Candidate Keys
then one is called Primary key and rest are called
Alternative Keys.
A key is formed by two or more columns is called Composite
Keys.
| Is This Answer Correct ? | 80 Yes | 28 No |
Post New Answer View All Answers
Explain the properties of subqueries in sql server?
How to drop an existing schema in ms sql server?
What are the different subsets of sql?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What happens if you are trying to access a schema not owned by you?
What are constraints in microsoft sql server?
What are approximate numeric data types in ms sql server?
How do I start sql server 2016?
Does a specific recovery model need to be used for a replicated database? : sql server replication
query processing
Why is the need for data conversion transformations?
What is the difference between Clustered and Non-Clustered Index?
How to get the definition of a user defined function back?
Where in ms sql server is ’100’ equal to ‘0’?
Define self join in sql server joins?
