Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115954 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
Is sql different from sql server?
Where do we use trace frag?
Introduction of rollup clause using sum and group by clause?
What is the default schema of your login session in ms sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
How do I port a number to sql server?
What is the difference function and stored procedure?
What is function of ROLLUP ?
Explain primary key?
Can a database be shrunk with users active?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What are different types of constraints?
Explain the use of containers in ssis and also their types?
Explain about system stored procedure?
