Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115527 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / anvar shadath.a
Candidate key: If any unique data column(s)in table is
called candidate key. may be one or more unique data column
(s).We can select any one unique (candidate key column) as
a primary key.
Alternate key: If one table contains more then one
candidate keys, remining candidate keys column(s) which is
not selected as a primary key is called Alternate Key.
Composite key: One primary key Contains more then one
columns is called Composite key.
| Is This Answer Correct ? | 75 Yes | 15 No |
Post New Answer View All Answers
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is the recovery model? List the types of recovery model available in sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What are wait types?
What do you understand by a view? What does the with check option clause for a view do?
How do you clear a log file?
What are the disadvantages of indexes?
How to enter binary string literals in ms sql server?
How to find the list of fixed hard drive and free space on server?
Is null in sql server?
Is there any difference between primary key and unique with the not null condition?
How do I find my localdb version?
How to transfer an existing table from one schema to another schema in ms sql server?
Explain what is the use of custom fields in report?
What are the results of running this script?
