Define candidate key, alternate key, composite key?
Answer Posted / kumaresan chandran
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 ? | 89 Yes | 27 No |
Post New Answer View All Answers
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How you can make a parameterized view?
What is dbms explain in brief?
Explain about normal forms?
Why does this query return 0?
Explain the rollup operator?
Explain about a primary key?
explain detail about ftp in datastage?
What is the physical representation for a many-to-many relationship?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Can an extended stored procedure be called from inside a user-defined function?
Explain about query and reporting.
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What is normalization? Explain different levels of normalization?
Which data type cannot be used as a parameter in a udf?