Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115507 Views
- Infosys, Software India, I also Faced
- E-Mail Answers
Answer Posted / swapna
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 ? | 348 Yes | 54 No |
Post New Answer View All Answers
What is the difference between set and select?
What is bulkcopy in sql?
What is de-normalization and what are some of the examples of it?
What is dbcc?
Explain about extended stored procedure?
How to use subqueries with the in operators in ms sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is difference between aggregate and analytic function?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What are the advantages of policy management?
What are logical database components? : SQL Server Architecture
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Can I save my report as html, excel or word? : sql server management studio
How to manipulate data from one table to another table ?
how you can configure a running aggregate in SSRS?
