Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 145659 Views
- IAS, IBM, I also Faced
- E-Mail Answers
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
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?
How long can an error message be in raiseerror function?
Where is dbms used?
What is database design and development?
How to replace not in with not exist?
How to read and create .LDC data files which are used by linguatic dictionary.
Which data type cannot be used as a parameter in a udf?
How would you design a database for an online site, which would average a million hits a day?
What are the 18 schemas?
What is data modeling with example?
What is the maximum length of an extended property?
In which table collections errors are stored.
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Who are naive users?
What are the key features of dbms?
