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 the difference between first normal form & second normal form?
Is oracle an open source?
How many data types are supported?
Explain oracle left join with an example?
Why is oracle used?
How to find the duplicate rows count from employees table in oracle?
How to Remove the 3rd highest salary person record from table?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
What is MTTR advisor in Oracle?
Difference between open_form and call_form in oracle.
candidate key is subset of super key but not vice-verse explain