Define candidate key, alternate key, composite key.
Answer Posted / kishore
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
New concepts of sql server 2005 use in your project.
Explain four layers of abstraction microsoft architectured?
Does sql server 2016 have ssms?
Write a query for primary key constraint with identity key word?
What is snapshot replication?
What is an sql server agent?
Where do we use trace frag?
What security features are available for stored procedure?
How do you know if sql server is running on your local system?
Can binary strings be converted into numeric or float data types?
Can sql server 2016 run on windows 7?
what data regions are and what are the different data regions?
Tell me extended events in sql server 2008?
Define model database?
Can you pass expressions to stored procedure parameters?