Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key.
- 13 Answers
- 115974 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
define and explain the differences between clustered and non-clustered indexes.
Which is better statement or preparedstatement?
How do I debug a stored procedure in sql server?
How can I check that whether automatic statistic update is enabled or not?
Write a query to find 5th highest amount paid from the customer table.
What are extended events in sql server?
What is database mirroring?
What is table valued function and scalar valued functions?
How many databases Microsoft SQL server provides?
What is policy based management (pbm)? : sql server database administration
Can I delete event logs?
Explain “not null constraint” in sql server?
How are the exceptions handled in sql server programming?
What is cdc in sql server?
What is user defined datatypes and when you should go for them?
