Define candidate key, alternate key, composite key.
- 13 Answers
- 111603 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 happens if null values are involved in datetime operations?
What do you understand by user-defined function in the sql server?
how to invoke a trigger on demand? : Sql server database administration
What is an example of a foreign key?
What are sparse columns?
What is page-level compression?
What are the advantages of using stored procedures?
What is filestream?
What is rank function?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What are the different types of indexes?
Can we insert data into a view?
What is log shipping?
Can you explain full-text query in sql server?
What are out-of-range errors with date and time literals?
