Define candidate key, alternate key, composite key.
- 13 Answers
- 113553 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
What is the recommended total size of your memory optimized tables?
what is create database syntax? : Sql server database administration
Explain an incremental backup?
What is 1nf 2nf?
Are all views updatable ?
Do you know what is difference between stored procedure and user defined function?
ow to bring suspect mode datbase online from scratch
Why use view instead of a table?
How to convert a numeric expression from one data type to another?
What number sorts of privileges are accessible in sql?
what is an index? : Sql server database administration
What happens if null values are involved in boolean operations?
What is 2nf in normalization?
What is the difference between a fill factor of 100 and 0?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
