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 |
Explain about functional dependency and its relation with table design?
What is meant by recursive hints ?
Use of an integrity constraint is better to validate data. Explain
What happens in oracle commit?
What is an oracle database?
What are inner join and outer join?
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
What do you mean by merge in oracle and how can we merge two tables?
what is candidate key & super key
How to define an anonymous block?
Can we commit inside a function in oracle?
What is the order of defining local variables and sub procedures/functions?