Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116034 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / amar
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 ? | 42 Yes | 14 No |
Post New Answer View All Answers
How to get a list of all tables with "sys.tables" view in ms sql server?
What are the differences between DDL, DML and DCL in SQL?
How many columns can exist together per table?
Can foreign key be deleted?
Explain ms sql server reporting services vs crystal reports?
what is the main function of a query parameter?
When a primary key constraint is included in a table, what other constraints does this imply?
what exactly sql injuction.how to overcome.....
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Can you explain important index characteristics?
What is transact-sql language?
How to create a Master database in SQL server ?
Define magic tables in sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are indexes in sql?
