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
What is sleeping status in sql server?
What is the difference between char, varchar and nvarchar?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How to update muliple row in single query?
What command is used to create a database in the sql server and how?
Can you use order by when defining a view?
What are the types of subquery?
Can I save my report as html, excel or word? : sql server management studio
What is sql server 2000 work load governor?
Mention the different types of triggers?
What is the difference between for trigger and after trigger?
Do you know what are acid properties?
What is data file in computer?
Do you know what is similarity and difference between truncate and delete in sql?
what are the different types of SSRS reports?