waht is the difference between primary key and super key?
Answer Posted / manoj jain
Primary key is subset of candidate key
primary key=not null+unique
candidate key is minimal form of super key ie. candidate key
is subset of super key
common feature:-
primary key,super key,candidate key is used to identify a
entity in relation
| Is This Answer Correct ? | 30 Yes | 4 No |
Post New Answer View All Answers
How can I combine multiple rows into a comma-delimited list in oracle?
Will you be able to store pictures in the database?explain.
Where is the export dump file located?
What is max rowid in oracle?
Explain overloading. Can functions be overloaded?
How to generate query output in html format?
How to use existing values in update statements using oracle?
How to divide query output into groups in oracle?
What is the quickest way to export a table to a flat file?
How to drop an index in oracle?
Explain compound trigger in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How to return top 5 rows in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is an oracle user account?