what is candidate key & super key
Answer / naresh
Cnadidate Key:
A Candidate Key (CK) is a column or group of columns that
uniquely describe every row in a table. The difficult thing
with this is that there may be exceptions in almost every
case. For instance, it is possible to have two people who
share the same name and birthdate but are really two
different people.
Super Key:
a superkey is a set of composite columns forming a key that
may be used to uniquely identify a row in a table
| Is This Answer Correct ? | 0 Yes | 0 No |
what is primary key?
what is the use of composite key constraint?
why can't we assign not null constraint as table level constraint
what are different types of deletes?
What is hot backup and logical backup?
what is kernel?
 How to use an oracle sequence generator in a mapping?
what is grid in Oracle 10g...
How to retrieve values from data fields in record variables?
What is user managed backup in Oracle?
How can we find out the duplicate values in an oracle table?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,