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 formal parameters and actual parameters?
How to create a testing table in oracle?
How to select some columns from a table in oracle?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
how to hide the stored procedure inside a package
Query to retrieve record for a many to many relationship ?
What is Index Cluster ?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Explain the importance of .pll extension in oracle?
Explain an exception and its types?
Explain an exception?
what are pseudocolumns?