Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 116486 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / kishore
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is 1nf 2nf and 3nf?
What are ddl (data definition language) statements for tables in ms sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is the maximum size of a row in sql server?
How to create a large table with random data for index testing in ms sql server?
What is read uncmmited?
Differentiate between delete and truncate.
How to modify an existing stored procedure in ms sql server?
Explain microsoft sql server functions?
What are the encryption mechanisms in sql server?
What is the difference between executequery () and executeupdate ()?
Explain what is raid and what are different types of raid levels?
When cursors are useful?
Describe in brief databases and sql server databases architecture.
